SQL Server - adding new column at specified position

arunrakwal · #1 (**permalink**) 07-27-2004, 06:34 AM

Adding a new column in existing table at specified position in SQL Server. In the middle of existing column set.

M0rtym0use · #2 (**permalink**) 07-27-2004, 07:02 AM

arunrakwal,
i am guessing you are actually asking a question here!
use the design view in enterprise manager to input the column where you require it.

MM

arunrakwal · #3 (**permalink**) 07-28-2004, 02:45 AM

THanks for reply,

Yes i am asking a question only.

I need to do this thru Script only.

And the new column is required in between the existing column set and not at the last position.

M0rtym0use · #4 (**permalink**) 07-28-2004, 05:35 AM

arunrakwal,
if you are going to be inserting columns using a script then i assume you are going to be querying the db also by script which menas it does not matter what order column names are in.

MM

swstyles · #5 (**permalink**) 08-05-2004, 03:55 PM

Enterprise manager is a GUI for sql scripting. Every command Enterprise Manager execute is a sql script execution. There is a command to do that but I don't konw what it is. Try asking your question at sqljunkies.com

http://www.sqljunkies.com

sqlmag.com was the best resource but they charge now for access. It's hard to find good tips these days.

hope this post was helpful.