2013/02/271 SQL Server 컬럼에 대한 Description 확인 쿼리 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 2013. 2. 27. 이전 1 다음