Mysql查询数据字典

SELECT

        a.TABLE_NAME as tableName,

b.TABLE_COMMENT as tableComment,

        a.COLUMN_NAME as columnName,

        a.COLUMN_COMMENT as columnComment,

        a.COLUMN_TYPE as columnType,

        null as length,

        null as scale,

        a.IS_NULLABLE as isNullable

        from information_schema.COLUMNS a

        LEFT JOIN information_schema.TABLES b ON a.TABLE_NAME=b.TABLE_NAME

        where a.TABLE_SCHEMA='hbsm' and a.TABLE_NAME 

in('t_sm_saleapply_benef_status')

order by a.TABLE_NAME

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/96210/viewspace-2158212/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/96210/viewspace-2158212/