Note: Temporary views exist in a special schema, so a schema name may not be given when creating a temporary view. The name of the view must be distinct from the name of any other view, table, sequence, or index in the same schema. Creating a view CREATE [OR REPLACE] [TEMP | TEMPORARY] VIEW name [ ( column_name [, ...] ) ] AS query Dropping a view DROP VIEW [IF EXISTS] name [, ...] [CASCADE | RESTRICT] |