SELECT t.[name] AS [表名],c.[name] AS [字段名],cast(ep.[value]
as varchar(100)) AS [字段说明]
FROM sys.tables AS t INNER JOIN sys.columns
AS c ON t.object_id = c.object_id LEFT JOIN sys.extended_properties AS ep
ON ep.major_id = c.object_id AND ep.minor_id = c.column_id WHERE ep.class =1
and t.[name]='t_wssb_wry_jbxx' //表名
and c.[name] = 'WRYBH'//字段
sql server 查询某表某字段说明
最新推荐文章于 2023-07-06 17:47:27 发布