H2 Create View
The H2 Create View Tool allows users to visually create views.
See the
Screen Shot for
a visual look:
For most databases, a view is simply a stored query that can be selected against similar to a table.
The Create View Tool allows the user to specify the view name and the query for the view, and then generates and/or executes the SQL needed to create the view.
The following is an example of the SQL generated from the Create View Tool
CREATE VIEW PUBLIC.TEST_VIEW AS select dname from department
Below is a screenshot of the H2 create view tool:
