Categories:
UDF (User-Defined Function) & Stored Procedure DDL

DROP MATERIALIZED VIEW

Removes the specified materialized view from the current/specified schema.

See also:
ALTER MATERIALIZED VIEW , CREATE MATERIALIZED VIEW , SHOW MATERIALIZED VIEWS

Syntax

DROP MATERIALIZED VIEW [ IF EXISTS ] <view_name>

Usage Notes

  • Dropping a materialized view does not update references to that view. For example, if you create a view named “V1” on top of a materialized view, and then you drop the materialized view, the definition of view “V1” will become out of date.

Examples

DROP MATERIALIZED VIEW mv1;

---------------------------+
           status          |
---------------------------+
 MV1 successfully dropped. |
---------------------------+