摘要： 1 SELECT 2 表名=case when a.colorder=1 then d.name else ' ' end, 3 字段序号=a.colorder, 4 字段名=a.name, 5 标识=case when COLUMNPROPERTY( a.id,a.name, 'IsIdentity ')=1 then '√ 'else ' ' end, 6 主键=case when exists(SELECT 1 FROM sysobjects where xtype= 'PK ' and name in ( 阅读全文