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

Examples