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 drops 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. You cannot drop a view that is referenced in another database object, such as another view, without using the CASCADE option. This will drop the view and all other views that reference the view being dropped.
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