re-ordering fields in a table

[PY88]

Is there a better way to re-ordering the fields in this tool than checking on/off the Invisible field?
I'd like to drag the field and have [View SQL] generate the SQL for turning the fields visible on / off in the correct order.
Thanks.

 

[Marco Kalter]

If you want to change the order of the columns of a table, you need to click on the "Recreate table" checkbox on the "General" page of the Table Definition Editor. Now you can drag & drop the columns on the "Columns" page to change the order.

Note that if you click "Apply" the table will be dropped and recreated, so any data will be lost.