alter column b/w desired column

if i have structure of table like a,b,c,d,e column then

i want to alter one more column x b/w b and c column, so that

a,b,x,c,d,e

Do you need to add the column to the table or do you want to do something with the records?

ALTER TABLE testTabelle ADD x NVARCHAR(20)

I don't know if the position of the column could be defined but is it really needed?
You can always define the position on quering:

SELECT a, b, x, c, d, e
FROM testTabelle|||Hi,

if you want to put a column in between, you can`t do it without recreating the whole table. Ordinal position are not relevant in the database, though they can be retrieved in a custom order by defining a view for getting the "ordered" columns.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de