CREATE VIEW
Creates a new virtual table based on the result set of a predefined SQL SELECT statement.
Syntax
CREATE VIEW [schema_name.]view_name
[(column_name[,column_name]...)]
AS <select-statement>Description
The list of column names for the view can be explicitly stated before the view's query, otherwise it is derived from the <select-statement>.