sql server如何查询表的字段类型和解释说明

sql server如何查询表的字段类型和解释说明

SELECT
A.name AS ‘表’ ,
B.name AS ‘字段’,
C.value AS ‘字段说明’,
D.DATA_TYPE ‘数据类型’ ,D.IS_NULLABLE as ‘是否为空’

FROM sys.tables A
INNER JOIN sys.columns B ON B.object_id = A.object_id
LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id AND C.minor_id = B.column_id
inner join information_schema.columns D on (B.name= D.COLUMN_NAME and A.name =D.TABLE_NAME )

WHERE A.name =‘要查询的表名’ order by column_id