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.
Syntax
drop_view::=
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.