HSQLDB Alter Table Drop Column
The RazorSQL alter table tool includes a Drop Column option for dropping a column from a HSQLDB database table. The drop column function allows the user to select a column to drop from the table. The tool then generates the appropriate alter table drop column SQL command for dropping the column from the table.
Listed below is an example of the SQL generated by the HSQLDB Alter Table Drop Column function:
ALTER TABLE PUBLIC.EMPLOYEE DROP COLUMN SSN
Below is a screen shot of the drop column function of the HSQLDB alter table tool.