MSSQL 테이블 정보 가져오기 쿼리

with dataset as (

SELECT 

A.TABLE_NAME, 

C.VALUE AS TABLE_COMMENT,

cast(C.VALUE as varchar) as TABLE_COMMENT2,

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

)

select * from dataset

where TABLE_COMMENT2 like '%테이블명%'

;