HSQLDB Rename Table
The RazorSQL alter table tool includes a Rename Table option for renaming an HSQLDB database table. The rename table option allows the user to type in a new name for the table being renamed. The tool then generates and can execute the SQL to rename the HSQLDB database table.
Listed below is an example of the SQL generated by the HSQLDB Rename Table function:
ALTER TABLE PUBLIC.EMPLOYEE RENAME TO EMPLOYEE_NEW
Below is a screen shot of the rename table function of the HSQLDB alter table tool.