MS-SQL

SELECT Column_Name 필드,'' 필드명,UPPER(Data_Type) 타입,  
		CASE WHEN    Data_Type   = 'Numeric' THEN    CAST(5 AS VARCHAR) + '(' + CAST(Numeric_Precision AS VARCHAR) + ')'  
			ELSE    ISNULL(CAST(Character_Maximum_Length AS VARCHAR),'')  END 크기,  
		CASE   WHEN    IS_Nullable = 'Yes' THEN    'Null'  
		ELSE   '' END [Null 여부]  
			FROM INFORMATION_SCHEMA.COLUMNS  
				WHERE Table_Name = 'board'  
					ORDER BY Ordinal_Position  

	SELECT OBJECT_NAME(object_id) 테이블,name 컬럼,TYPE_NAME(system_type_id) 타입,
		max_length 크기, precision 정밀도, CASE WHEN is_nullable = 1 THEN 'NULL' ELSE 'NOT NULL' END Null허용여부
		FROM    sys.columns
		   WHERE   OBJECT_NAME(object_id) = N'board'