34,593
社区成员
发帖
与我相关
我的任务
分享
SELECT [表名] = c.name ,
[表说明] = ISNULL(f.[value], '') ,
[列名] = a.name ,
[列说明] = ISNULL(e.[value], '') ,
[默認值] = ISNULL(d.text, '') ,
a.object_id ,
a.column_id
FROM sys.columns a
LEFT JOIN sys.types b ON a.user_type_id = b.user_type_id
INNER JOIN sys.objects c ON a.object_id = c.object_id
AND c.type = 'U'
LEFT JOIN syscomments d ON a.default_object_id = d.id
LEFT JOIN sys.extended_properties e ON e.major_id = c.object_id
AND e.minor_id = a.column_id
AND e.class = 1
LEFT JOIN sys.extended_properties f ON f.major_id = c.object_id
AND f.minor_id = 0
AND f.class = 1
WHERE EXISTS ( SELECT 1
FROM sys.objects x
JOIN sys.indexes y ON x.type = N'PK'
AND x.name = y.name
JOIN sysindexkeys z ON z.id = a.object_id
AND x.parent_object_id = z.id
AND z.indid = y.index_id
AND z.colid = a.column_id );