[MSSQL] 테이블 필드의 설명 구하기
SELECT A.tableName, A.columnName, isnull(A.value,'') as memo, CONCAT(B.name,'(',A.max_length,')') as sType, CASE WHEN (C.COLUMN_NAME IS NULL) THEN 'NO' ELSE 'YES' END AS defaultKey FROM ( SELECT A.*, B.minor_id, B.value FROM ( SELECT A.name as tableName, A.object_id as tableID, B.name as columnName, B.column_id, B.system_type_id, B.max_length FROM sys.tables A INNER JOIN sys.columns B ON A.objec..
2018. 2. 27.
