Hi Benoit.
>I alredy know the command ALTER TABLE .... to modify a table. I'm able to add fields, but they are always added as the last field. I would like to know how to insert a field at the position I want or to only change the position of an existing field. Of course, I want to do this by programmation...
Check out Stonefield Database Toolkit (SDT). Among its many utilities is the ability to update the structure of a table in a production environment, including inserting a field in the middule of the table structure. For more information or a demo version of SDT, go to
www.stonefield.com.
Doug