㏈ª By β┖υΕJini/MS-SQL
SQL Server 컬럼에 대한 Description 확인 쿼리
BLUEJINI.KR
2013. 2. 27. 16:36
SELECT [Table Name] = OBJECT_NAME(c.object_id) ,
[Column Name] = c.name ,
[Description] = ex.value
FROM sys.columns c
LEFT OUTER JOIN sys.extended_properties ex ON ex.major_id = c.object_id
AND ex.minor_id = c.column_id
AND ex.name = 'MS_Description'
WHERE OBJECTPROPERTY(c.object_id, 'IsMsShipped') = 0
AND OBJECT_NAME(c.object_id) = '테이블명'
ORDER BY OBJECT_NAME(c.object_id) ,
c.column_id