sqlserver 2008获取列备注信息

SELECT A.name As 表明,B.Name As 列名,
B.xtype As 列类型,C.Value As 字段说明
FROM sysobjects As A INNER JOIN syscolumns As B ON A.id = B.id
INNER JOIN sys.extended_properties As C ON C.major_id = A.id
AND ( minor_id = B.colid)

转载于:https://www.cnblogs.com/lanyue52011/archive/2012/08/31/2664875.html