Is getting table-comments out of SQL Server with selects possible?

Hi,
We have used Enterprise Manager to add comments to all our column
definitions. Unfortunately, the only place we can see these comments are in
the windows of Enterprise Manager. We would like to be able to query for
these comments, just like it is possible to query for the names of all
tables and columns from systables, sysobjects, information_schema.tables
etc.
For example
use master
select * from information_schema.columns
So, anyone who can say where our comments are stored (we sure hope they are
stored inside the database in more or less clear text somewhere).
Best regards,
Helge G Solheim, MCSD
Computas
hgs at computasnospam dot comIt is in sysproperties, but the supported measures you find if you search BOL for "extended
properties". For instance the fn_listextendedproperty() function.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Helge G Solheim" <hgs@.nospam.org> wrote in message news:OdmqwJCiDHA.2320@.TK2MSFTNGP12.phx.gbl...
> Hi,
> We have used Enterprise Manager to add comments to all our column
> definitions. Unfortunately, the only place we can see these comments are in
> the windows of Enterprise Manager. We would like to be able to query for
> these comments, just like it is possible to query for the names of all
> tables and columns from systables, sysobjects, information_schema.tables
> etc.
> For example
> use master
> select * from information_schema.columns
> So, anyone who can say where our comments are stored (we sure hope they are
> stored inside the database in more or less clear text somewhere).
> Best regards,
> Helge G Solheim, MCSD
> Computas
> hgs at computasnospam dot com
>