scys1217的专栏

查出表的各个字段的所有属性 SELECT 表名 = case when a.colorder=1 then d.name else '' end, 表说明 = case when a.colorder=1 then isnull(f.value,'') else '' end, 字段序号 = a.colorder, 字段名 = a

Select o.name AS tableName, c.name AS columnName, p.[value] AS Description    FROM sysproperties p INNER JOIN          sysobjects o ON o.id = p.id INNER JOIN          syscolumns c ON p.id = c.id AN