DROP VIEW

Purpose

Use this statement to delete a view.

Prerequisite

• You need either the system privilege USE ANY SCHEMA or the object privilege USAGE on the target schema, or the schema must be owned by you or one of your assigned roles.

• You need the system privilege DROP ANY VIEW, or the view must be owned by you or one of your assigned roles.

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;