基于sql server2016测试通过,应该通用与SQLserver2005以上版本。
SELECT
c.name as columnName,
a.VALUE as columnDescript
FROM
sys.extended_properties a,
sysobjects b,
sys.columns c
WHERE
a.major_id = b.id
AND c.object_id = b.id
AND c.column_id = a.minor_id
AND b.name = ‘要查询的表名’
SQL server 2016 查询表的字段注释
最新推荐文章于 2024-08-13 18:17:17 发布