查询表的字段含义

select a.name tabname,a1.name '字段',b.value '字段描述' from sysobjects a
left join sys.columns a1 on a.id = a1.object_id
left join sys.extended_properties b on b.major_id = a.id and b.minor_id = a1.column_id
where a.name='test' --表名称