mssql 2008 코멘트 보기

SELECT a.object_id AS TABLE_ID, a.name AS TABLE_NAME, b.name AS COLUMN_NAME, b.column_id AS COLUMN_ID, c.value AS DESCRIPTION
FROM sys.objects a
 LEFT JOIN sys.columns b ON a.object_id=b.object_id
 LEFT JOIN sys.extended_properties c ON (a.object_id=c.major_id AND b.column_id=c.minor_id)
where a.name = '테이블명'
ORDER BY a.object_id, b.column_id;