mssql 20081 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; 2013. 3. 4. 이전 1 다음