테이블정의서
-
[MSSQL] 테이블 정의서 작성 쿼리DB 2018. 9. 14. 00:05
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657SELECT A.COLUMN_NAME as 컬럼명 , A.DATA_TYPE as 데이터타입 , CASE WHEN A.CHARACTER_MAXIMUM_LENGTH IS NULL THEN ISNULL (A.NUMERIC_PRECISION, '') ELSE A.CHARACTER_MAXIMUM_LENGTH END AS [길이] , CASE WHEN A.COLUMN_DEFAULT is null THEN '' ELSE A.COLUMN_DEFAULT END AS [기본값] , CASE WHEN C.TABLE_NAME IS NOT N..