All Products
Search
Document Center

DROP VIEW

Last Updated: Jun 18, 2021

Description

This statement deletes one or more views.

Note

The current user must have the DROP permission on each view.

Syntax

drop_view_stmt:
    DROP VIEW view_name [CASCADE | RESTRICT];

Parameter description

Parameter

Description

view_name

The name of the view to be deleted.

CASCADE | RESTRICT

CASCADE and RESTRICT are parsed and ignored.

Examples

  • Delete the view v1.

OceanBase(root@oceanbase)>drop view v1;