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;