MS-SQL
테이블 코멘트 조회 쿼리
캡틴노랑이
2015. 7. 27. 13:44
반응형
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
반응형