page1
Changing columns by GUI produces corrupt tables
There are four fields in the table. The field „Birthday“ is formatted as „Date“.
Now the table should be edited again. There are shown some possibilities in the contextmenu of the mouse.
Added a field „Street“, cut the field „Birthday“ and paste the field „Birthday“.
It's possible to save this changed table without any warning. For any user the GUI shows, that it might be possible to cut and paste a field.
And now a look at the content of the edited table: There is a „Street“, shown as a date in the internal date-format of the HSQLDB. The format of this field is „Varchar“. The field „Birthday“ has been added without content.
If the GUI allows to cut and paste fields of a table, the user might think it would allow to cut and paste the whole content of a field. So he would corrupt the table with his action.
There is no way to change the order of the columns in the GUI. The only way is SQL:
ALTER TABLE "test" ADD "Street" VARCHAR(25) BEFORE "Birthday";