生成单张表的数据库字典

select distinct
a.COLUMN_NAME as '字段名称',
a.COLUMN_COMMENT as '字段含义',
a.COLUMN_TYPE as '类型长度',
a.IS_NULLABLE as '允许空值',
case when b.CONSTRAINT_NAME='PRIMARY'  then '主键' else '' end  as '注'
from INFORMATION_SCHEMA.COLUMNS as a
left join INFORMATION_SCHEMA .KEY_COLUMN_USAGE  as b
on a.COLUMN_NAME = b.COLUMN_NAME
and a.table_name = b.table_name
and b.CONSTRAINT_NAME='PRIMARY'
where a.table_name like ‘xxxxxx’

 

注：

将上述sql语句，最后一句的“xxxxxx”换成需要生成数据字典的表的名称即可。