MS-SQL 테이블 정보 얻는 쿼리(테이블스키마)

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

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 = '테이블명' ORDER BY A.TABLE_NAME, A.ORDINAL_POSITION