Getting the column description from SQL Server

[rguti]

Hi,

Does anybody know how to get the column description for a table in SQL
Server 2000?

Thanks.

[Zoury]

Hi!

Look up the sp_columns stored procedure in the T-SQL reference :

ex :
-- in T-SQL
sp_columns 'my_table'

--
Best Regards
Yanick Lefebvre

"rguti" <te**@test.com> a écrit dans le message de
news:uc**************@TK2MSFTNGP09.phx.gbl...

Hi,

Does anybody know how to get the column description for a table in SQL
Server 2000?

Thanks.

[rguti]

Hi,

I looked at the sp_columns but unfortunately it doesn't give the
description.
"Zoury" <ya*************@hotmail.com> wrote in message
news:#Z**************@TK2MSFTNGP12.phx.gbl...

Hi!

Look up the sp_columns stored procedure in the T-SQL reference :

ex :
-- in T-SQL
sp_columns 'my_table'

--
Best Regards
Yanick Lefebvre

"rguti" <te**@test.com> a écrit dans le message de
news:uc**************@TK2MSFTNGP09.phx.gbl...

Hi,

Does anybody know how to get the column description for a table in SQL
Server 2000?

Thanks.

[David Lownds]

try sp_help tablename.

Cheers

Dave
"rguti" <te**@test.com> wrote in message
news:#0**************@tk2msftngp13.phx.gbl...

Hi,

I looked at the sp_columns but unfortunately it doesn't give the
description.
"Zoury" <ya*************@hotmail.com> wrote in message
news:#Z**************@TK2MSFTNGP12.phx.gbl...

Hi!

Look up the sp_columns stored procedure in the T-SQL reference :

ex :
-- in T-SQL
sp_columns 'my_table'

--
Best Regards
Yanick Lefebvre

"rguti" <te**@test.com> a écrit dans le message de
news:uc**************@TK2MSFTNGP09.phx.gbl...

Hi,

Does anybody know how to get the column description for a table in SQL
Server 2000?

Thanks.

[rguti]

No luck, it's not there
"David Lownds" <da***@dlownds.f2s.com> wrote in message
news:2l************@uni-berlin.de...

try sp_help tablename.

Cheers

Dave
"rguti" <te**@test.com> wrote in message
news:#0**************@tk2msftngp13.phx.gbl...

Hi,

I looked at the sp_columns but unfortunately it doesn't give the
description.
"Zoury" <ya*************@hotmail.com> wrote in message
news:#Z**************@TK2MSFTNGP12.phx.gbl...

Hi!

Look up the sp_columns stored procedure in the T-SQL reference :

ex :
-- in T-SQL
sp_columns 'my_table'

--
Best Regards
Yanick Lefebvre

"rguti" <te**@test.com> a écrit dans le message de
news:uc**************@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> Does anybody know how to get the column description for a table in SQL > Server 2000?
>
> Thanks.
>
>

[Imran Koradia]

select value from ::fn_listextendedproperty ('MS_Description', 'user',
'dbo', 'table', 'MyTable', 'column', 'Column1')
'MS_Description' is the description property of the column that you are
looking for; 'MyTable' is the table name and
'Column1' is the column for which you want the description. Note the special
syntax of this function (two prefixed colons) .
You can lookup the syntax and example of this function in sql server books
online for further details.
"rguti" <te**@test.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Hi,

I looked at the sp_columns but unfortunately it doesn't give the
description.
"Zoury" <ya*************@hotmail.com> wrote in message
news:#Z**************@TK2MSFTNGP12.phx.gbl...

Hi!

Look up the sp_columns stored procedure in the T-SQL reference :

ex :
-- in T-SQL
sp_columns 'my_table'

--
Best Regards
Yanick Lefebvre

"rguti" <te**@test.com> a écrit dans le message de
news:uc**************@TK2MSFTNGP09.phx.gbl...

Hi,

Does anybody know how to get the column description for a table in SQL
Server 2000?

Thanks.

[rguti]

Thanks! That did it.
"Imran Koradia" <no****@microsoft.com> wrote in message
news:uw**************@TK2MSFTNGP11.phx.gbl...

select value from ::fn_listextendedproperty ('MS_Description', 'user',
'dbo', 'table', 'MyTable', 'column', 'Column1')
'MS_Description' is the description property of the column that you are
looking for; 'MyTable' is the table name and
'Column1' is the column for which you want the description. Note the special syntax of this function (two prefixed colons) .
You can lookup the syntax and example of this function in sql server books
online for further details.
"rguti" <te**@test.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

Hi,

I looked at the sp_columns but unfortunately it doesn't give the
description.
"Zoury" <ya*************@hotmail.com> wrote in message
news:#Z**************@TK2MSFTNGP12.phx.gbl...

Hi!

Look up the sp_columns stored procedure in the T-SQL reference :

ex :
-- in T-SQL
sp_columns 'my_table'

--
Best Regards
Yanick Lefebvre

"rguti" <te**@test.com> a écrit dans le message de
news:uc**************@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> Does anybody know how to get the column description for a table in SQL > Server 2000?
>
> Thanks.
>
>