add column in ordinal positions

[nnani]

Hello All,

Can we a add a column into an existing table at a specific ordinal position.

I can see the ordinal postions of columns in the columns table, If I want to add a column in middle of ordinal positions, Can we do it.
Is there some different alter table statement.

I want to do it using Alter table statement.

Thanks

[JimKnicely]

Hi,

I believe you have to create a temp table and projections with your new column, copy data into it for the original table, drop your old table and rename the new table to the old table.