Querying database tables with their descriptions
I want to query an SQL server database for specific tables and their descriptions. How do I do that? Is there a special tool needed to do this?
Software/Hardware used:
Software/Hardware used:
ASKED:
May 11, 2009 10:01 AM
UPDATED:
May 11, 2009 2:36 PM
Answer Wiki:
I think this could do the trick:
<pre>SELECT o.name, e.value
FROM sys.objects o JOIN sys.extended_properties e
ON o.object_id = e.major_id AND
e.name = N'MS_Description'
WHERE e.minor_id = 0
AND o.name = 'you_table';</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
