sql server用SQL语句查看字段说明

最新推荐文章于 2024-08-20 22:53:45 发布

weixin_30235225

最新推荐文章于 2024-08-20 22:53:45 发布

阅读量617

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/amusement1992/p/10682486.html

版权

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='表名'

转载于:https://www.cnblogs.com/amusement1992/p/10682486.html