Ms sqlserver 查询表注释和字段注释Sqlserver查询所有表名及其描述
作者:小编
更新时间:2023-08-09
点击数:
SELECT
A.name AS table_name,/*表名*/
B.name AS column_name,/*列名*/
C.value AS column_description/*注释*/
FROM sys.tables A
INNER JOIN sys.columns B ON B.object_id = A.object_id
LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id AND C.minor_id = B.column_id
WHERE A.name = '表名'