SQL Server - adding new column at specified position

[arunrakwal]

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

[M0rtym0use]

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]

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]

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]

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.