CREATE VIEW

Owned by Former user (Deleted)
Jan 18, 2018
1 min read

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 query

Description

The list of column names for the view can be explicitly stated before the view's query, otherwise it is derived from the query.

See Also

DROP VIEW

SELECT