I have Table A with 5 columns:
TableA -- Name Tel Email Address
I want to add a new column (mobile) in between Tel & Email:
TableA -- Name Tel Mobile Email Address
If I use
ALTER TABLE TableA ADD COLUMN Mobile INT NOT NULL
the mobile column is added to the end of the table.
Is there a way to achieve this without dropping the table and moving data to a new table?