Removes a materialized view.
DROP MATERIALIZED VIEW [ IF EXISTS ] <name> [, ...] [ CASCADE | RESTRICT ]
DROP MATERIALIZED VIEW
drops an existing materialized view. To run this command, you must be the owner of the materialized view.
This command removes the materialized view called order_summary
.
DROP MATERIALIZED VIEW order_summary;
DROP MATERIALIZED VIEW
is a Greenplum Database extension of the SQL standard.
ALTER MATERIALIZED VIEW, CREATE MATERIALIZED VIEW, REFRESH MATERIALIZED VIEW
Parent topic: SQL Commands