All Products
Search
Document Center

DROP VIEW

Last Updated: Jun 18, 2021

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;