[MS-SQL] 테이블 데이터, 길이 등 보기편하게 조회 하는 법

SELECT  
A.COLUMN_NAME,'','',B.VALUE AS COLUM_COMMENT,'','','', 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.IS_NULLABLE 
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 IN ( 
    /* 여기에 테이블명 입력 (Enter table name here) */  
) 
ORDER BY A.TABLE_NAME, A.ORDINAL_POSITION;