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 one of the user roles.

Syntax

drop_view::=

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 RESTRICT or CASCADE are not of much significance in this command. However, they are supported syntactically for compatibility reasons.

Example

DROP VIEW my_view;