[MS-SQL] Table Description(명세서) 쿼리
-- Table Description ver 2.0 --SELECT A.TABLE_SCHEMA , A.TABLE_NAME , A.COLUMN_NAME , B.ColumnDescription , C.CONSTRAINT_NAME , A.ORDINAL_POSITION , A.DATA_TYPE , CASE WHEN A.CHARACTER_MAXIMUM_LENGTH IS NULL THEN convert(varchar(20), isnull(A.NUMERIC_PRECISION, 0)) + ',' + convert(varchar(20), isnull(A.NUMERIC_SCALE , 0)) ELSE convert(varchar(20), A.CHARACTER_MAXIMUM_LENGTH ) END AS LENGTH , A.I..
더보기