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...
>

Retrieving data types is slow

Hello,

i'm using SMO to retrieve information from various databases. It works
well except for one thing. When I call the Column.DataType property to
get the SQL type of a column it takes a very long tine. I have a few
databases, each with some tables. There are about 75 columns I think.
If I just browse all columns with SMO and write each name if it not a
system one, it takes about 15 seconds (pretty much anyway). If I also retrieve the data type
it takes about one minute. Any ideas why? The server is a local one.

Thanksstarted reading Michiel's articles. The issue will be fixed shortly I think. Thanks anyway.