Hi Tony,

> Does anyone know if it is possible to drop a column, then add a new
> one so it shows up in the same position as the old one?

Yes. First drop the column, then add the new one (ALTER TABLE MYTABLE
ADD MYNEWCOLUMN...) then set the new column to the desired position
like this:

ALTER TABLE MYTABLE ALTER MYNEWCOLUMN POSITION 3;

The position is 1-based.


Greetings,
Paul Vinkenoog