Title: DROP MATERIALIZED VIEW Author: The PostgreSQL Global Development Group Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/> Date: 2017 Manual: PostgreSQL 9.6.5 Documentation Source: PostgreSQL 9.6.5 Language: English
NAMEDROP_MATERIALIZED_VIEW - remove a materialized view
DROP MATERIALIZED VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DROP MATERIALIZED VIEW drops an existing materialized view. To execute this command you must be the owner of the materialized view.
- Do not throw an error if the materialized view does not exist. A notice is issued in this case.
- The name (optionally schema-qualified) of the materialized view to remove.
- Automatically drop objects that depend on the materialized view (such as other materialized views, or regular views).
- Refuse to drop the materialized view if any objects depend on it. This is the default.
This command will remove the materialized view called order_summary:
DROP MATERIALIZED VIEW order_summary;
DROP MATERIALIZED VIEW is a PostgreSQL extension.