DROP VIEW
Description
You can execute the DROP VIEW statement to delete one or more views. Note
Before you execute this statement, ensure you have the global DROP permission.
Syntax
drop_view_stmt:
DROP VIEW [IF EXISTS] view_name_list [CASCADE | RESTRICT];
view_name_list:
view_name [, view_name_list]
Parameters
| Parameter | Description |
|---|---|
| IF EXISTS | If you add IF EXISTS to the statement and the specified views do not exist, the system does not return an error. |
| view_name_list | If some views you specify in view_name_list do not exist, the system may return an error. However, the system still deletes the views that exist. |
| CASCADE | RESTRICT | CASCADE and RESTRICT are parsed and ignored. |
Examples
Execute the following statements to delete views v1 and v2: Assume that v1 or v2 does not exist. If you execute the first statement, the system returns an error.
drop view v1, v2;
drop view if exists v1, v2;