Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Column Description Expand / Collapse
Author
Message
Posted Tuesday, June 4, 2002 3:40 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 31, 2003 12:00 AM
Points: 141, Visits: 1
Is there a way to get the column description from the tables in a db?

I created a script to get table and column name, but I have not a clue if I can get the field description. Anyone knows where, if possbile, to get those field descriptions?


What I have is

Column1 column2
Table Column Name
Employee FName

we need

Column1 column2 column3
Table Column Name Column Desc
Employee FName First Name

Any suggestions?

Thank you




Post #4618
Posted Tuesday, June 4, 2002 4:34 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, September 15, 2014 9:16 AM
Points: 6,784, Visits: 1,895
See if this article helps any:

http://www.sqlservercentral.com/columnists/mcurnutt/datadictionaryfromwithinsqlserver2000.asp

Andy
http://www.sqlservercentral.com/columnists/awarren/




Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #34990
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse