In my informations there is currently now comfortable non-SQL way to rearange the order of the fields presented in the table-edit-window.
I would suggest a simple up- and down-button in the toolbar for that.
(In reply to c.buhtz from comment #0)
> In my informations there is currently now comfortable non-SQL way to
> rearange the order of the fields presented in the table-edit-window.
> I would suggest a simple up- and down-button in the toolbar for that.
You are right, there isn't. The GUI has been created for many different database-engines. The internal database-engine HSQLDB only allows to set the position of a new field by SQL, not to change the position of existing fields. Firebird would allow to position fields after adding them. So you could change the position at every time. Might be other database-engines won't allow to change the position at all.
Have set this one to "NEW", because there isn't any possibility to change the sorting order.
Have set the version to "Inherited from OOo", because it never worked in an other way.