SQL Server Performance Forum – Threads Archive

Column Description

After I enter a description for a column, how can I retreive it programmatically? Besides the Column Properties page, will I see the description in any other SQL Server features? Thanks, Peter

Would this help?
SELECT
objname As ‘Column’
, value As ‘Description’
FROM
::fn_listextendedproperty
(‘caption’, ‘user’, ‘dbo’, ‘table’,’T1′, ‘column’,default)
—
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

]]>