34,590
社区成员
发帖
与我相关
我的任务
分享
select object_name(a.object_id) 'TableName', a.column_id,a.name,
isnull(b.value,'') 'comment'
from sys.columns a
left join sys.extended_properties b
on a.object_id=b.major_id and a.column_id=b.minor_id
where a.object_id=object_id('[表名]')