Where is stored Columns Description for SQL Server Tables?

[Maria]

I am a beginer in SQL Server and if someone knows I would like to know
where are stored columns description - am refering at that column
description that can be write for each column when you create a table
in a SQL Server Database using SQL Server Enterprise Manager.
I want to get this information from the database and display it in a
C# application, I 've tryed COLUMNPROPERTY function and sp_columns
procedure, but this are not giving me the column definition, only
type, name, etc
Thanks
Maria

[John Bell]

Hi

Check out fn_listextendedproperty() in books online.

John

"Maria" <t_*******@email.ro> wrote in message
news:aa**************************@posting.google.c om...

I am a beginer in SQL Server and if someone knows I would like to know
where are stored columns description - am refering at that column
description that can be write for each column when you create a table
in a SQL Server Database using SQL Server Enterprise Manager.
I want to get this information from the database and display it in a
C# application, I 've tryed COLUMNPROPERTY function and sp_columns
procedure, but this are not giving me the column definition, only
type, name, etc
Thanks
Maria

[Maria Tosa-Abrudan]

Hi,
It works. Thanks John
Maria
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

[Pali]

Hi,

as far I know, for geting description of column is suitable to use for
example this statement:

SELECT * FROM ::fn_listextendedproperty (null , N'user', N'dbo',
N'table', N'ADM_SERIAL_COEF', N'column', N'SERIAL_COEF_ID')

[Anith Sen]

Refer to:
http://groups.google.com/groups?selm...TNGP09.phx.gbl

--
Anith