[MSSQL] 테이블 정보 조회
SELECT A.TABLE_NAME AS 테이블명 , C.VALUE AS 테이블코멘트 , A.COLUMN_NAME AS 컬럼ID , A.COLUMN_NAME AS 컬럼명 , A.DATA_TYPE AS 데이터타입 , CASE A.DATA_TYPE WHEN 'varchar' THEN CONVERT(VARCHAR(10), A.CHARACTER_MAXIMUM_LENGTH) WHEN 'numeric' THEN CONVERT(VARCHAR(10), A.NUMERIC_PRECISION) + ',' + CONVERT(VARCHAR(10), A.NUMERIC_SCALE) END 길이 , CASE WHEN A.COLUMN_NAME = ISNULL(E.COLUMN_NAME, '') AND D.CONSTRAINT_TYPE =..
2023. 3. 10.