Retrieving other table-column properties

SQL 2K ...
I need to retrieve the Description property for some columns in a table.
It is not available in: select * from INFORMATION_SCHEMA.Columns where
table_name = 'mytable'
or from select * from syscolumns
Anyone know how to access it?Use the fn_listextendedproperty function for this. It is documented in Book
s Online. Also, search
for "extended properties" for more information.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Sydney Lotterby" <sydney@.infosearch.com> wrote in message
news:Ok8hPLjYGHA.428@.TK2MSFTNGP02.phx.gbl...
> SQL 2K ...
> I need to retrieve the Description property for some columns in a table.
> It is not available in: select * from INFORMATION_SCHEMA.Columns where
table_name = 'mytable'
> or from select * from syscolumns
> Anyone know how to access it?
>|||Thanks. That is what I needed.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:O%23mHJwjYGHA.3704@.TK2MSFTNGP03.phx.gbl...
> Use the fn_listextendedproperty function for this. It is documented in
> Books Online. Also, search for "extended properties" for more information.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Sydney Lotterby" <sydney@.infosearch.com> wrote in message
> news:Ok8hPLjYGHA.428@.TK2MSFTNGP02.phx.gbl...
>