how to get column's descriptive text in tables

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

how to get column's descriptive text in tables

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-12 : 09:24:23

santiago writes "i am a developper using vbasic & Ms. sql server and i would like to know how to get the column's descriptive text in tables using a querie. I've tried with sqldmo, but i cannot find the correct way for doing that. Thak's a lot"

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-07-12 : 09:43:34

Can you define "column's descriptive text"?

<O>

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2002-07-12 : 12:10:07

if he's talking about name, size etc.....the following link may point in the right direction........

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=14851

also a search on "schema" should be informative....

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2002-07-16 : 11:08:14

the following should be more helpful....

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=17772

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-07-16 : 15:23:29

Check out fn_listextendedproperty in BOL and see the link above for an example.

HTH
Jasper Smith

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources