is it possible to add a new column inbetween the existing column instead of at the last using alter script?

Question

I think Subject explains clearly

Answer 1

You need to drop and recreate, and use like a temp table to move the data.
Even when you use SSMS, the GUI interface, that's how it works behind the scene, it drops and recreates the table.

---

Abdallah, PMP, ITIL, MCTS

Answer 2

Abdshall told you corectly.

You might want to read this for more information:  http://databases.aspfaq.com/general/how-do-i-change-column-order-in-a-table-structure.html

---

--Brad (My Blog)