SQL 语句查询表字段信息，及字段备注

SELECT a.NAME as tableName, b.NAME as columnName, type_name(b.xtype) as columnType,
b.length as columnLength, c.value as extendProperty
FROM sysobjects AS a
LEFT JOIN syscolumns AS b
ON a.id =b.id
LEFT JOIN sys.extended_properties AS c
ON b.id = c.major_id AND b.colid = c.minor_id
WHERE a.NAME in ('city', 'account','person') --你可以用你的表面替代这里的'city','account'...
order by a.NAME