SELECT
A.TABLE_SCHEMA '数据库',
A.TABLE_NAME '表名',
A.COLUMN_NAME '表列名',
A.ORDINAL_POSITION '表字段顺序号',
A.DATA_TYPE '列的数据类型',
A.COLUMN_TYPE '列的类型',
A.COLUMN_COMMENT '列的备注'
FROM INFORMATION_SCHEMA.COLUMNS A
WHERE A.TABLE_SCHEMA='库名'
ORDER BY A.TABLE_SCHEMA,A.TABLE_NAME,A.ORDINAL_POSITION
12-15
5797
09-18
1793
08-04
3651