Use this statement to delete a view.
You need to have the system privilege DROP ANY VIEW, or the view belongs to the current user , or one of the user roles.
- 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.