
复制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]=table1 or t.[name]=table2 and c.[name] in (table2字段,table2字段) or c.[name] in (table1字段,table1字段) 1.2.3.4.5.6.7.8.


相关文章
精彩导读
热门资讯
关注我们
