컬럼 정보 보기 쿼리
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,CASE WHEN ISNULL(D.NAME,'') = '' THEN '' ELSE 'auto_increment' END EXTRAFROM INFORMATION_SCHEMA.COLUMNS A LEFT OUTER J..
더보기