select
A.name as 表名, --表名
B.name as 字段, --列名
D.name as 类型, -- 类型
case B.is_nullable when 0 then '是' else '否' end as 是否必填,
C.value as 说明 --列名备注
from sys.tables A
inner join sys.columns B on B.object_id = A.object_id
left join sys.types D on D.system_type_id=B.system_type_id
left join sys.extended_properties C on C.major_id = B.object_id and C.minor_id = B.column_id
where A.name = '表名'and D.name!='sysname' order by column_id