March 11, 2002 at 3:40 pm
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
March 11, 2002 at 5:48 pm
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
March 13, 2002 at 7:32 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply