Query for table info....

Hello,
What table / column would I query to get the DESCRIPTION
from a table.
This query does not include the Column_Description
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS WHERE
TABLE_NAME = 'service_ticket'
order by Column_name
Thanks in advance,
Bobuse fn_listextendedproperty , change 'YourTable' to the name of your
table
SELECT * FROM ::fn_listextendedproperty (null, 'user', 'dbo', 'table',
'YourTable', 'column',
default)
http://sqlservercode.blogspot.com/|||That's awesome...
Thanks much!
Bob
"SQL" <denis.gobo@.gmail.com> wrote in message
news:1141310307.524701.104020@.i39g2000cwa.googlegroups.com...
> use fn_listextendedproperty , change 'YourTable' to the name of your
> table
> SELECT * FROM ::fn_listextendedproperty (null, 'user', 'dbo', 'table',
> 'YourTable', 'column',
> default)
>
> http://sqlservercode.blogspot.com/
>sql