DROP MATERIALIZED VIEW

The DROP MATERIALIZED VIEW statement removes the specified materialized 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.

Usage with TimesTen Scaleout

This statement is supported with TimesTen Scaleout.

SQL syntax

DROP MATERIALIZED VIEW [Owner.]ViewName

Parameters

Parameter	Description
`[Owner.]ViewName`	Identifies the materialized view to be dropped.

Description

When you execute a DROP MATERIALIZED VIEW operation, 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 materialized view.

DROP MATERIALIZED VIEW custorder;