ALTER TABLE via SQL

[anonymous]

[Originally posted by ARPRINCE]

How do you add a field in a table in a specific order? Let's say I want to add/insert a new field as the second field of an existing table or anywhere within the current structure of the table?

Possible?

Tnx.

[anonymous]

[Originally posted by Pieter van Vuuren]

I don't believe you can specify the positioning of fields with the alter table statement, would be nice though, but you can create a temp table copy your data in there, recreate your table and then copy your data back in. If you have SQL 7 or 2000 the change script does something like that.

cheers