drop_materialized_view(7)

NAME#

DROP_MATERIALIZED_VIEW - remove a materialized view

SYNOPSIS#

DROP MATERIALIZED VIEW [ IF EXISTS ] \nname\n [, ...] [ CASCADE | RESTRICT ]

DESCRIPTION#

DROP MATERIALIZED VIEW drops an existing materialized view. To execute this command you must be the owner of the materialized view.

PARAMETERS#

IF EXISTS

name

CASCADE

RESTRICT

EXAMPLES#

This command will remove the materialized view called order_summary:

DROP MATERIALIZED VIEW order_summary;

COMPATIBILITY#

DROP MATERIALIZED VIEW is a PostgreSQL extension.

SEE ALSO#

CREATE MATERIALIZED VIEW (CREATE_MATERIALIZED_VIEW(7)), ALTER MATERIALIZED VIEW (ALTER_MATERIALIZED_VIEW(7)), REFRESH MATERIALIZED VIEW (REFRESH_MATERIALIZED_VIEW(7))