We use the following to get the description for each column.
SELECT OBJECT_NAME(c.object_id) as TableName, c.name AS ColumnName, ex.value AS Description FROM sys.columns AS c INNER JOIN sys.extended_properties AS ex ON ex.major_id = c.object_id AND ex.minor_id = c.column_id AND ex.name = 'MS_Description' AND ex.class_desc = 'OBJECT_OR_COLUMN' WHERE (OBJECTPROPERTY(c.object_id, 'IsMsShipped') = 0)
However if 2 tables have the same name (different schemas), then we can't tell which is which. How can I get the schema too? Also, is the the best way to get the descriptions in ver 9+?
Also, is the following the best way to get it in
View Complete Post