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 can’t be recovered; they must be recreated.

  • When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.

Examples

DROP MATERIALIZED VIEW mv1;

---------------------------+
           status          |
---------------------------+
 MV1 successfully dropped. |
---------------------------+
Copy
Language: English