View Full Version : SQL Server - adding new column at specified position
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.
07-27-2004, 07:02 AM
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.
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.
07-28-2004, 05:35 AM
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.
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
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.