Column1 MSSQL / column comment / add , update, delete - 조회 SELECT obj.name AS TableName, col.name AS ColumnName, ep.value AS ColumnComment FROM sys.extended_properties AS ep INNER JOIN sys.objects AS obj ON ep.major_id = obj.object_id INNER JOIN sys.columns AS col ON ep.major_id = col.object_id AND ep.minor_id = col.column_id WHERE obj.type_desc = 'USER_TABLE' AND ep.class_desc = 'OBJECT_OR_COLUMN' AND ep.name = 'MS_Description'; - 주석 추가 EXEC sp_ad.. 2024. 2. 26. 이전 1 다음 반응형