DROP MATERIALIZED VIEW

Syntax

DROP { MATERIALIZED VIEW | MV } mv-name

Description

This statement drops an MV.

Options

mv-name: Specifies the current name of the MV to be dropped. mv-name is in the [catalog-name.][schema-name.]mv-name form, where each part of the name is a valid SQL identifier. It can have maximum 128 characters.

Permissions

To drop an MV, you must own the schema or be the super ID or object owner or hold DROP permission on the schema containing the MV.

Example command

>>DROP MATERIALIZED VIEW HR_DETAILS;

--- SQL operation complete.