SQL Server 查所有表的字段的信息
select b.name as [表名] ,a.name as [列名],c.name as [列类型],a.max_length as [列类型长度],cast(ep.[value]
as varchar(100)) AS [字段说明]
from sys.columns a
inner join sys.tables b on b.object_id=a.object_id
inner join sys.types c on c.system_type_id=a.system_type_id
LEFT JOIN sys.extended_properties AS ep
ON ep.major_id = a.object_id AND ep.minor_id = a.column_id WHERE ep.class =1