By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,572 Members | 1,439 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,572 IT Pros & Developers. It's quick & easy.

Getting the column description from SQL Server

P: n/a
Hi,

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

Thanks.
Nov 20 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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.

Nov 20 '05 #2

P: n/a
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.


Nov 20 '05 #3

P: n/a
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.



Nov 20 '05 #4

P: n/a
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.
>
>



Nov 20 '05 #5

P: n/a
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.



Nov 20 '05 #6

P: n/a
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.
>
>



Nov 20 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.