DROP MATERIALIZED VIEW

DROP MATERIALIZED VIEW

Syntax

drop_mview ::=

Prerequisites

Only the following users can delete the materialized view using this statement:

• The SYS user

• The owner of the Materialized view

• The user with the system privilege of DROP ANY MATERIALIZED VIEW

Description

This statement deletes the specified materialized view from the database.

IF EXISTS

If the IF EXISTS clause is used, the DROP statement runs without error even if the materialized view does not exist.

user_name

This specifies the owner name of the materialized view to be deleted. On omission, Altibase deletes the materialized view of the current user's schema.

mview_name

This specifies the name of the materialized view to be deleted.

Example

<Query> Delete the materialized view with the name mv1.

DROP MATERIALIZED VIEW mv1;