SQL SERVER
HOW CAN I ADD A COLUMN BETWEEN TWO COLUMN IN SQL SERVER 2008.
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.
Sanjeeb LenkaPosted Sep 26, 2013, 2:26 AM
you cannot insert a new column between two existing one using a query or a script. Using GUI, you can by selecting the column row in table-design and choosing insert a column option.
The main thing is why does that matter at all? There is no difference in which order a particular column lies in SQL table. You can always have desired result in your queries and views designed based on the tables.
Posted Sep 26, 2013, 1:47 AM