how to insert a new column between 2 column in a Table in MSSQL 2008?

[santhanalakshmi]

hi,

i have the following columns :

empno empname designation


In between empname and designation, i want to add new column location.

empno empname location designation.

Thanks in advance

[gpl]

use alter table / add column

The order of columns really shouldnt matter as you can place them in any order in your select query

[santhanalakshmi]

Its k, fine. What do you told ? I want to know, whether its it possible to add like this or not in MS SQL 2008.

Possible to add columns in between the columns ?

[ck9663]

You can add a column, but not insert. In theory, relational databases does not care about the sequence of the column nor rows. At least in theory. This because you can specify the sequence of these columns, anyway....

If you really need to, create a table with that new column inserted, then populate it with your data coming from the original table.

Good Luck!!!

~~ CK