在你要导出数据字典的数据空中右键,新建查询,执行如下代码即可 代码如下: SELECT (case when a.colorder=1 then d.name else ” end)表名,d.xtype as 表类型, a.colorder 字段序号, a.name 字段名, (case when COLUMNPROPERTY( a.id,a.name,’IsIdentity’)=1 then ‘√’else ” end) 标识, (case when (SELECT count(*) FROM sysobjects WHERE (name in (SELECT name FROM sysi