DROP [MATERIALIZED] VIEW

The DROP [MATERIALIZED] VIEW statement deletes the specified view, including any hash indexes and any range indexes associated with it.

Required privilege

View owner or DROP ANY [MATERIALIZED] VIEW (if not owner) and
Table owner or DROP ANY TABLE (if not owner) and
Index owner or DROP ANY INDEX (if not owner) if there is an index on the view

SQL syntax

DROP [MATERIALIZED] VIEW ViewName

Parameters

The DROP VIEW statement has the parameters:

Parameter	Description
`MATERIALIZED`	Specifies that the view is materialized.
`ViewName`	Identifies the view to be dropped.

Description

When you perform a DROP VIEW operation on a materialized view, the detail tables are updated and locked. An error may result if the detail table was already locked by another transaction.

Examples

The following statement drops the custorder view.

DROP VIEW custorder;