테이블 명세서 VIEW
SELECT A.TABLE_NAME, C.VALUE AS TABLE_COMMENT, A.ORDINAL_POSITION, A.COLUMN_NAME, B.VALUE AS COLUM_COMMENT, A.COLUMN_DEFAULT, A.IS_NULLABLE, 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 FROM INFORMATION_SCHEMA.COLUMNS A LEFT OUTER JOIN SYS.EXTENDED_PROPERTIES B ON B.MAJOR_ID = Obje..
더보기
