2.3.40 CREATE VIEW

Table of Contents Previous Next


2 The SQL Language : 2.3 SQL Commands : 2.3.40 CREATE VIEW

CREATE VIEW -- define a new view
CREATE [ OR REPLACE ] VIEW name [ ( column_name [, ...] ) ]
AS query
CREATE VIEW defines a view of a query. The view is not physically materialized. Instead, the query is run every time the view is referenced in a query.
CREATE OR REPLACE VIEW is similar, but if a view of the same name already exists, it is replaced.
If a schema name is given (for example, CREATE VIEW myschema.myview ...) then the view is created in the specified schema. Otherwise it is created in the current schema. The view name must be distinct from the name of any other view, table, sequence, or index in the same schema.
A query (that is, a SELECT statement) which will provide the columns and rows of the view.
Refer to SELECT for more information about valid queries.

2 The SQL Language : 2.3 SQL Commands : 2.3.40 CREATE VIEW

Table of Contents Previous Next