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

SQLDMO Column Description property Expand / Collapse
Author
Message
Posted Monday, March 11, 2002 3:40 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, October 4, 2007 10:09 AM
Points: 198, Visits: 2
sqldmo doesn't seem to expose the DESCRIPTION property of a column. note: this can be edited in SQL SERVER Enterprise Mgr (sql2000)

Is there anyway to obtain this description property of a column via sqldmo.

thanks in advance

Brian Lockwood
President
LockwoodTech Software



Brian Lockwood
President
ApexSQL - SQL Developer Essentials

http://www.apexsql.com/blog

Stand up for an Independent SQL Community - be Informed
Post #2975
Posted Monday, March 11, 2002 5:48 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, September 15, 2014 9:16 AM
Points: 6,784, Visits: 1,895
Not that I can find. You can always retrieve it using ADO, either by doing select name, value from sysproperties where object_name(id)='categories' and name='ms_description' or you can look at using fn_listextendedproperty to avoid directly reading from system tables. The first way looks to be the cleanest, you could pull all of them for an entire table or db over at once.






Andy


Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #29657
Posted Wednesday, March 13, 2002 7:32 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, October 4, 2007 10:09 AM
Points: 198, Visits: 2
quote:

Not that I can find. You can always retrieve it using ADO, either by doing select name, value from sysproperties where object_name(id)='categories' and name='ms_description' or you can look at using fn_listextendedproperty to avoid directly reading from system tables. The first way looks to be the cleanest, you could pull all of them for an entire table or db over at once.






Andy




great thanks

Brian Lockwood
President
LockwoodTech Software



Brian Lockwood
President
ApexSQL - SQL Developer Essentials

http://www.apexsql.com/blog

Stand up for an Independent SQL Community - be Informed
Post #29658
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse