DROP VIEW

Description

DROP VIEW deletes a view from a database.

Precautions

The owner of a view, owner of the schema of the view, users granted with the DROP permission on the view, or users granted with the DROP ANY TABLE permission can run the DROP VIEW command. When separation of duties is disabled, system administrators have this permission by default.

Syntax

DROP VIEW [ IF EXISTS ] view_name [, ...] [ CASCADE | RESTRICT ];

Parameters

IF EXISTS
Reports a notice instead of an error if the specified view does not exist.
view_name
Specifies the name of the view to be deleted.

Value range: an existing view name
CASCADE | RESTRICT
- CASCADE: cascadingly deletes the objects (such as other views) that depend on the view.
- RESTRICT: refuses to delete the view if any objects depend on it. This is the default action.