info > DROP_MATERIALIZED_VIEW(7)

man perldoc info pydoc3 ri search

📛 NAME

DROP_MATERIALIZED_VIEW - remove a materialized view

🚀 Quick Reference

Use Case	Command	Description
Drop a materialized view	DROP MATERIALIZED VIEW order_summary;	Remove the materialized view
Drop if exists (avoid error)	DROP MATERIALIZED VIEW IF EXISTS order_summary;	No error if view missing, just notice
Drop with cascading dependencies	DROP MATERIALIZED VIEW order_summary CASCADE;	Drop view and all dependent objects
Drop multiple views at once	DROP MATERIALIZED VIEW view1, view2, view3;	Remove several views in one command

📋 SYNOPSIS

DROP MATERIALIZED VIEW [ IF EXISTS ] name [, ...] [ 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 – Do not throw an error if the materialized view does not exist. A notice is issued in this case.
• 📛 name – The name (optionally schema-qualified) of the materialized view to remove.
• ⛓️ CASCADE – Automatically drop objects that depend on the materialized view (such as other materialized views, or regular views), and in turn all objects that depend on those objects (see Section 5.14).
• 🚫 RESTRICT – Refuse to drop the materialized view if any objects depend on it. This is the default.

💡 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))

📛 NAME 🚀 Quick Reference 📋 SYNOPSIS 📖 DESCRIPTION ⚙️ PARAMETERS 💡 EXAMPLES 🌐 COMPATIBILITY 📚 SEE ALSO