DROP MATERIALIZED VIEW

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

See also:

ALTER MATERIALIZED VIEW , CREATE MATERIALIZED VIEW , SHOW MATERIALIZED VIEWS , DESCRIBE MATERIALIZED VIEW

Syntax

DROP MATERIALIZED VIEW [ IF EXISTS ] <view_name>
Copy

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.

  • Dropped materialized views cannot be recovered; they must be recreated.

Examples

DROP MATERIALIZED VIEW mv1;

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