Drop View
Purpose
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.
