DROP VIEW

DROP VIEW — remove a view.

Syntax

DROP VIEW
    [IF EXISTS] [CASCADE | RESTRICT] [schema.] view_name
DROP VIEW
    [schema.] view_name [IF EXISTS] [CASCADE | RESTRICT]

Description

DROP VIEW removes an existing view from a database. To execute this command, you must be the owner of the view.
You can change the definition of a view by dropping and recreating it.
IF EXISTS, CASCADE and RESTRICT can occur before or after view_name.
Refer to CREATE VIEW for information about how to create views.

Parameters

schema: Optional. The name of the schema that owns the view to be dropped. If schema is not provided, the view must be owned by the current schema.
view_name: Name (optionally schema-qualified) of an existing view.
CASCADE: Provided for backwards compatibility but ignored.
RESTRICT: Provided for backwards compatibility but ignored.
IF EXISTS: If the view does not exist and you specify IF EXISTS, NuoDB does not generate an error. Otherwise, if the view does not exist, an error is generated.

Examples

Example 1: Dropping a view.

USE TEST
DROP TABLE IF EXISTS table1;
DROP VIEW IF EXISTS view1;
CREATE TABLE table1 (column1 INTEGER);
CREATE VIEW view1 AS SELECT column1 FROM table1;
DROP VIEW view1;

DROP VIEW nosuchview;
  can't find view "NOSUCHVIEW"

DROP VIEW nosuchview IF EXISTS;