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>.

See Also

DROP VIEW

SELECT