Syntax:
CREATE VIEW [ IF NOT EXISTS ] view-name AS select-statement
The CREATE VIEW command assigns a name to a pre-packaged SELECT statement. Once the view is created, it can be used in the FROM clause of another SELECT statement instead of the table name.
One cannot COPY, DELETE, INSERT or UPDATE a view. Views are read-only in GDBase. Views are removed with the DROP VIEW command.