I am able to add new column/rename using alter table .


alter table Mytable add RegionID char(9) null


now I want to add column description for RegionID as 'ApproverRegions'

can i do it using alter table ???
or is there any way to do this,since I want dbScript.

I can directly open the table "mytable" in design mode and put the column over there
at the same time I can put Description as "It's Approver Region".

Is there any clue or pointer to do the same.

Awaiting for your reply



Cheers :)

vinod

__________________
Cheers :)

vinod

The description is an 'extended property' implemented in SQL Server. It is not part of the SQL Standard DML, so it cannot be accessed by DML code such as ALTER TABLE.

There are a number of system stored procedures sych as sp_addextendedproperty and sp_updateextendedproperty which allow you to create and/or update these things. IMO, they are more than a little annoying to use. YMMV.

Jeff Mason
[email protected]

HI Jeff!!
Great one, i was exactly looking on this,thank you very much !!

Cheers :)

vinod

BTW, I used the tem 'DML' (Data Manipulation Language) in my reply incorrectly, it should have been 'DDL' (Data Definition Language').

My apologies.

Jeff Mason
[email protected]