mssql 테이블 명세서 조회

--테이블 코멘트 조회 
SELECT 
OBJTYPE, 
OBJNAME, 
NAME, 
VALUE 
FROM ::FN_LISTEXTENDEDPROPERTY (NULL, 'SCHEMA', 'DBO', 'TABLE', '테이블명', DEFAULT, DEFAULT); 

--컬럼 코멘트 조회 
SELECT 
OBJTYPE, 
OBJNAME, 
NAME, 
VALUE 
FROM ::FN_LISTEXTENDEDPROPERTY(NULL, 'SCHEMA', 'DBO', 'TABLE', '테이블명', 'COLUMN', DEFAULT); 

--테이블 정보 조회 쿼리 
SELECT 
A.TABLE_NAME, 
C.VALUE AS TABLE_COMMENT, 
A.COLUMN_NAME, 
A.DATA_TYPE, 
ISNULL(CAST(A.CHARACTER_MAXIMUM_LENGTH AS VARCHAR), CAST(A.NUMERIC_PRECISION AS VARCHAR) + ',' + CAST(A.NUMERIC_SCALE AS VARCHAR) ) AS COLUMN_LENGTH , 
A.COLUMN_DEFAULT , 
A.IS_NULLABLE , 
B.VALUE AS COLUM_COMMENT 
FROM INFORMATION_SCHEMA.COLUMNS A 
LEFT OUTER JOIN SYS.EXTENDED_PROPERTIES B ON B.MAJOR_ID = OBJECT_ID(A.TABLE_NAME) 
AND A.ORDINAL_POSITION = B.MINOR_ID LEFT OUTER JOIN (
SELECT OBJECT_ID(OBJNAME) AS TABLE_ID , VALUE 
FROM ::FN_LISTEXTENDEDPROPERTY (NULL, 'USER','DBO','TABLE', NULL, NULL, NULL) ) C ON OBJECT_ID(A.TABLE_NAME) = C.TABLE_ID 
WHERE A.TABLE_NAME = 'TEST'--"테이블명" 
ORDER BY A.TABLE_NAME, A.ORDINAL_POSITION