DROP MATERIALIZED VIEW
Function
DROP MATERIALIZED VIEW forcibly deletes an existing materialized view from the database.
Precautions
Only the owner of a materialized view or a system administrator has the DROP MATERIALIZED VIEW permission.
Syntax
DROP MATERIALIZED VIEW [ IF EXISTS ] mv_name [, ...] [ CASCADE | RESTRICT ];
Parameter Description
IF EXISTS
Reports a notice instead of an error if the specified materialized view does not exist.
mv_name
Name of the materialized view to be deleted.
CASCADE | RESTRICT
- CASCADE: automatically deletes the objects that depend on the materialized view.
- RESTRICT: refuses to delete the materialized view if any objects depend on it. This is the default action.
Example
-- Delete the materialized view named my_mv.
postgres=# DROP MATERIALIZED VIEW my_mv;
Link
ALTER MATERIALIZED VIEW, CREATE INCREMENTAL MATERIALIZED VIEW, CREATE MATERIALIZED VIEW, CREATE TABLE, REFRESH INCREMENTAL MATERIALIZED VIEW, REFRESH MATERIALIZED VIEW
Feedback