カラムのコメントを取得するSQL

SqlServer カラムのコメントを取得するSQL

SELECT
        T.NAME AS TABLE_NAME,
        C.NAME AS COLUMN_NAME,
        EP.VALUE AS COMMENT
FROM
        SYS.TABLES T,
        SYS.COLUMNS C,
        SYS.EXTENDED_PROPERTIES EP
WHERE
        T.NAME = 'TEST_TABLE'
	AND T.OBJECT_ID = C.OBJECT_ID
	AND C.OBJECT_ID = EP.MAJOR_ID
	AND C.COLUMN_ID = EP.MINOR_ID ;