Hi,

> 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, that's possible. You can set a column position.

However, the database engine itself doesn't care at all.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com