Skip to content
≡

Administrator

Developer

Tools

External Tools

DROP MATERIALIZED VIEW

DROP MATERIALIZED VIEW#

Syntax#

drop_mview ::=#

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.

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;