This content has been marked as final. Show 3 replies
As NKU and Sysbrand pointed out there's no real need to to put a new column in a specific place. Relational theory allows for the columns to be anywhere in a table row so the order should not matter.
If you must put the column in a specific place you will have to do a lot of work. Back up the old table for safety. Create a new table with the new column where you want it. Copy the old data to the new table. Recreate any indexes, constraints, etc. Drop the old table. Rename the new table to the old name. Drop the backup if everything is okay after testing.
Easier just to add the column to the end of the table.