I have migrated a few of my databases over to SQL 2.3.
Now I have tried to rename a column in base with this command:
Alter table “TABLE NAME” rename column “COLUMN NAME” to “NEW COLUMN NAME”
If I use “table name” and “column name”… I get this;
unexpected token: COLUMN required: TO
If I use no quotation marks, I get this:
user lacks privilege or object not found: PUBLIC.TABLE NAME
Also I note that in the GUI in Base, when open the table to edit by right clicking, I can no longer change the names of the columns and save the changes as I could under HSQL 1.8.
One the same token I note that a table itself cannot be renamed anymore simply by right clicking.
Are there any solutions?