man > DROP_MATERIALIZED_VIEW(7)

man perldoc info pydoc3 ri search

🚀 Quick Reference

Use Case	Command	Description
🗑️ Basic drop	DROP MATERIALIZED VIEW order_summary;	Remove a materialized view
✅ Drop if exists	DROP MATERIALIZED VIEW IF EXISTS order_summary;	Avoid error if the view is missing
🔗 Drop with cascade	DROP MATERIALIZED VIEW order_summary CASCADE;	Also drop dependent objects
📦 Drop multiple views	DROP MATERIALIZED VIEW view1, view2;	Remove several views at once
🛡️ Drop with restrict (default)	DROP MATERIALIZED VIEW order_summary RESTRICT;	Refuse if dependencies exist

📛 NAME

🗑️ DROP MATERIALIZED VIEW — remove a materialized view

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

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