H2 Alter Table
The H2 Alter Table Tool allows users to visually alter tables. The Alter
Table Tool can generate and/or execute the SQL that corresponds
to any table alterations specified by the user.
See the
Screen Shot for
a visual look:
The following options are available for the H2 Alter Table Tool.
Add Column - Adds a column to a table
Add Primary Key - Adds a primary key to a table
Add Foreign Key - Adds a foreign key to a table
Add Constraint - Adds a check constraint to a table
Drop Column - Drops a column from a table
Drop Constraint - Drops a check constraint from a table
Listed below are some sample SQL statements generated by the Alter Table Tool.
ALTER TABLE PUBLIC.DEPARTMENT ADD NEW_COL CHAR(25)=
ALTER TABLE PUBLIC.DEPARTMENT ADD PRIMARY KEY (DNUMBER)
Below is a screenshot of the H2 alter table tool:
