블로그 이미지
불쥐의 눈으로 본세상 ㏈ª ☞ β┖υΕJini.κR

카테고리

분류 전체보기 (234)
By β┖υΕJini (131)
㏈ª By β┖υΕJini (103)
Total282,918
Today4
Yesterday23

'2013/02/27'에 해당되는 글 1건

  1. 2013.02.27 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

 

Posted by ㏈ª ☞ β┖υΕJini.κR