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)
 SQL-DMO - Adding a column

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-03-13 : 07:47:52
Roberta writes "When adding a column to a table is there a way to tell SQL where to insert the column? I don't want the column to be added to the bottom of the table."

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2003-03-13 : 08:06:25
We have many posting regarding this.
you can do it only by EM. Otherwise drop and recreate the table.

Sekar
~~~~
Success is not a destination that you ever reach. Success is the quality of your journey.
Go to Top of Page

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2003-03-13 : 08:09:14
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=24488

Sekar
~~~~
Success is not a destination that you ever reach. Success is the quality of your journey.
Go to Top of Page
   

- Advertisement -