MSSQL1 테이블정보 조회 SELECT OBJECT_NAME(c.object_id) "Table_Name" , c.name "Column_Name" , c.column_id "No." , TYPE_NAME(c.system_type_id) "Type Name" , c.max_length "Size" , c.is_identity "Identity" , c.is_nullable "Allow_Null" , ex.value "Description" FROM sys.columns c LEFT OUTER JOIN sys.extended_properties ex ON ex.major_id = c.object_id AND ex.minor_id = c.column_id AND ex.name = 'MS_Description' WHERE OBJECTP.. 2011. 3. 11. 이전 1 다음