Purpose

The Drop View statement drops a view.

Syntax

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

where:

view_name
specifies the name of a view.
IF EXISTS
specifies that an error is not to be returned if the view does not exist.
RESTRICT
is in effect by default, meaning that the drop fails if any other view refers to this view.
CASCADE
silently drops all dependent views.