Adding column between two other columns in SQL server

Asked 2011-03-16T15:25:32.533

Can you add a column to a table inserting it in between two existing columns in SQL Server without dropping and re-creating the table?

sql-server alter-table

Edit Report

1 Answer

Take a look at this link:

As you can see, the answer is:

'not possible without moving data to a temp table'

which is what the SQL Server Management Studio actually does.

answered 2011-03-16T15:32:44.260