SELECT
d.NAME 表名,
a.NAME 字段名,
b.NAME 字段类型,
g.VALUE 字段说明
FROM
syscolumns a
LEFT JOIN systypes b ON a.xtype = b.xusertype
INNER JOIN sysobjects d ON a.id = d.id AND d.xtype = 'U' AND d.NAME <> 'dtproperties'
LEFT JOIN sys.extended_properties g ON a.id = g.major_id
AND a.colid = g.minor_id
where
d.NAME ='数据表名'