SQL SERVER

Question

HOW CAN I ADD A COLUMN BETWEEN TWO COLUMN IN SQL SERVER 2008.

Sanjeeb Lenka · Answer

HI 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.

Muralidharan Deenathayalan · Answer

Add the column in the last then you should be able to move the column using designer or table edit window.