SELECTc.TABLE_NAME,c.COLUMN_NAME,c.DATA_TYPE,c.IS_NULLABLEFROMINFORMATION_SCHEMA.COLUMNScWHEREc.TABLE_NAMEIN(demo_202608-- 任意一张气表分表)ORDERBYc.TABLE_NAME,c.ORDINAL_POSITION;
非常实用的查询表字段相关信息sql语句
SELECTc.TABLE_NAME,c.COLUMN_NAME,c.DATA_TYPE,c.IS_NULLABLEFROMINFORMATION_SCHEMA.COLUMNScWHEREc.TABLE_NAMEIN(demo_202608-- 任意一张气表分表)ORDERBYc.TABLE_NAME,c.ORDINAL_POSITION;
)
)
![[光学原理与应用-521]：对光的错误理解与纠偏](http://pic.xiahunao.cn/yaotu/[光学原理与应用-521]：对光的错误理解与纠偏)
