>>Create the new table using the CREATE TABLE command, with the correct ordering of fields. Then APPEND FROM the original table.
>>
>Hmm, it seems to me that original table will still have old field order after that. :)

Oh, I left the rest as an excercise for the reader.

Just forgot to give the assignment. :)