Alter Table

Hello all,

I've got a question about the ALTER TABLE statement for adding columns in SQL Server. I can do something like:

ALTER TABLE table ADD column ...

Is there a way to add a column before or after another column? I couldn't find how in whatever reference I have seen.

Thnx in advance.

you need to build the new table with older data ..

with sql statment...

create table aa select col1,col2,col3 from mytable