본문 바로가기
MS-SQL

테이블 코멘트 조회 쿼리

by 캡틴노랑이 2015. 7. 27.
반응형

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS T1
LEFT OUTER JOIN (
 SELECT
  T.NAME TABLE_NAME, TD.VALUE TABLE_DESC
  , C.NAME COLUMN_NAME, CD.VALUE COLUMN_DESC
 FROM SYSOBJECTS T
 INNER JOIN SYSUSERS U ON U.UID = T.UID
 LEFT OUTER JOIN SYS.EXTENDED_PROPERTIES TD ON TD.MAJOR_ID = T.ID AND TD.MINOR_ID = 0 AND TD.NAME = 'MS_Description'
 INNER JOIN SYSCOLUMNS C ON C.ID = T.ID 
 LEFT OUTER JOIN SYS.EXTENDED_PROPERTIES CD ON CD.MAJOR_ID = C.ID AND CD.MINOR_ID = C.COLID AND CD.NAME = 'MS_Description'
 WHERE T.TYPE = 'u'
) T2 ON T2.TABLE_NAME=T1.TABLE_NAME AND T2.COLUMN_NAME=T1.COLUMN_NAME
WHERE T1.TABLE_NAME = 'TB_PB_REGLR_SCHEDSCRPTREQ'
ORDER BY ORDINAL_POSITION

반응형

댓글