SQL中快速查询表名称，字段和说明

Jayzai

于 2015-03-08 23:26:16 发布

阅读量1.2k

点赞数 1

CC 4.0 BY-SA版权

文章标签： sql

本文链接：https://blog.youkuaiyun.com/jayzai/article/details/44141161

本文提供了一段SQL查询代码，用于从SQL Server数据库中获取指定表‘T_BrokerWithLook’的所有字段名称及其对应的注释说明。通过联接多个系统表及视图来实现这一目标。

SELECT 
t.[name] AS 表名,
c.[name] AS 字段名,
cast(ep.[value] as nvarchar(200)) 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_BrokerWithLook'