CREATE VIEW

Creates a new view object in the database.

Syntax

CREATE VIEW [ IF NOT EXISTS ] view-name
[ ( column-alias-name [,...] ) ]
    AS sub-query
[ WITH CHECK OPTION ]

where sub-query is a limited syntax of the SELECT statement.