>Hello,
>
>Currently we are using the ALTER TABLE command to add new fields to existing tables.
>
>These new fields always append to the bottom of the tables.
>
>What command can we use to move these new fields to somewhere other than the bottom of the tables? Say, if we wanted to move them to the middle?
>
>Thanks!
>Joeeeeeeeee

Hi Joe,
Using simple SQL commands, you can't. SDT has this functionality built in. You can check out their website. This and many other functions make this a must have (IMO).

If you want to roll your own for this, you have to rename the table. Create an array with the current structure using AFIELDS. Insert array rows/columns into your array using AINS(). Then create a new table using the array (i.e. create table NewTable from array MyArray) and then append your information from the old table to the new one.

Good luck!