How to add New column in Required position
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Joginder BangerPosted Aug 3, 2016, 5:44 AM
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 KumarPosted Aug 3, 2016, 5:41 AM
How to add New column in Required position in sql server
Midhun TpPosted Aug 3, 2016, 5:37 AM