LO Base - How to move columns?

[jtm4890]

How can I move the columns’ location? For example, move the ID column to the end?

[RobertG]

You have created the table in Firebird? Then you could change the sorting by

ALTER TABLE "Table1" ALTER "ID" POSITION 9;

but sometimes the position has been changed but the GUI for the table won’t show it.
With internal HSQLDB you could only set the position while inserting a new field, not after a field has been inserted.
And as @Villeroy commented earlier: You could position the fields in queries, forms and views. So if you need a special position create a query and input values directly in a query.

[fpy]

How do I change the order of fields when I edit a table? base 5.0.3.2

The order of rows and columns in a database table is insignificant. You can easily create queries that return the exact same data in any order of rows and columns you want. Then you can use a query instead of the table. Open the query designer, add one table and add the columns in any order you want. Optionally you can use alias names to change the column names on the fly. This query with modified column order works in the exact same ways as the original table.