SELECT
表名= case when a.colorder=1 then d.name else '' end,
主健名=h.Name,
字段序号 = a.colorder,
主健字段名
= a.nameFROM
syscolumns aleft join
systypes b on
a.xusertype=b.xusertypeinner join
sysobjects d on
a.id=d.idand d.xtype='U' andd.name'dtproperties'inner joinsyso...