当前位置: 代码迷 >> SQL >> SQL中高速 查询表名称,字段和说明
  详细解决方案

SQL中高速 查询表名称,字段和说明

热度:88   发布时间:2016-05-05 10:43:21.0
SQL中快速 查询表名称,字段和说明
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'


 

  相关解决方案