DROP VIEW

Purpose

Use this statement to delete a view.

Prerequisite

You need to have the system privilege DROP ANY VIEW, or the view belongs to the current user or to one of the user roles.

Syntax

Usage Notes

• If the optional IF EXISTS clause is specified, then the statement does not throw an exception if the view does not exist.
• The options RESTRICTor CASCADE are not of much significance in this command. However, they are supported syntactically for compatibility reasons.

Example

DROP VIEW my_view;