Hi all!
I’m creating a table in Base. I would like to add another field to that table. I don’t want to add it at the end of the field list; I want to add it in between other fields. Can this be done? How?
Thanks in advance!
Execute SQL code such as the following in the SQL panel in Base (Menu: Tools>SQL):
ALTER TABLE "your_table" ADD COLUMN "new_column" VARCHAR(100) BEFORE "existing_column";
You will need to insert the actual names of your table, new column, and an existing column just below where you want your new column INSERTED. You can specify INTEGER, VARCHAR and the other column-types supported by your database ‘engine’ (probably HSQLDB). You should see a “Command successfully executed” message after the command is run, and you will need to do a table REFRESH to see the result (Menu: VIEW>Refresh tables)