How to add New column in Required position

Question

Joginder Banger · Answer

Hello sanjeev You have to create a temp table that mirrors the original table's schema but with the column order that you want then copy the contents of the original to temp. Delete the original and rename the temp. This is what SQL Management Studio does behind the scenes. With a schema sync tool you can generate these scripts automatically.

Sanjeev Kumar · Answer

How to add New column in Required position in sql server

Midhun T P · Answer

Hi AFAIK you cannot insert a column between two columns using query in SQL. There is some other way you can do that. Check the link below - http://www.oratable.com/add-table-column-at-specific-position/