simple ALTER Table query question...SQL 2000.

Ok I have a table with fields as follows:
field1
varchar(10)

field2
varchar(10)

field3
varchar(10)

Identity
int
Indenity field

I want to create a ALTER table to add fields field2a and field2b right
after field2 and not at the end of the table. Any way to do this?

Thanks,
David

The order of the columns does not matter as you define the column order when
writing queries in your SELECT statement.

If you really want to accomplish this, you can create table with temporary
name with the desired column sequence, then insert the data from the
original table into the new table, drop the old table, and rename the new
table to the original table name (using sp_rename). Since you have IDENTITY
column you may have to use SET IDENTITY_INSERT to ON to preserve the column
values.

HTH,

Plamen Ratchev
http://www.SQLStudio.com