jamesmuglia

Greetings, can anyone please tell me how to insert a new column at a given location in the table. Say that there are 10 fields in the table and we want the new column we're adding to show up as the fourth column in the table. I know we insert a new column by saying

ALTER TABLE Table
ADD NewColumn
NULL

but how do we specify which column number that we would like it to be?
Thanks so much!
Jim

KesleyK

I don't think you can insert a new field at a specific index in a table. However, you may be able to move it once you have it added.

If it comes down to it, you could create a new table with the columns in the order you want one at a time. Delete the old table and rename the new one. *SHRUG* Just an option...

______
Cheers!