你的位置:首页 > 软件开发 > 数据库 > SqlServer字段说明查询

SqlServer字段说明查询

发布时间:2016-08-24 15:00:07
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.obj ...
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='TableName'

原标题:SqlServer字段说明查询

关键词:sql

sql
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。