DROP_MATERIALIZED_VIEW(7pg13)

🎀 DROP_MATERIALIZED_VIEW 🎀

okay so bestie, welcome to the DROP_MATERIALIZED_VIEW page from the PostgreSQL 13.23 Documentation — manual DROP_MATERIALIZED_VIEW(7pg13) — and it's literally the guide for yeeting a materialized view. 💅✨

---

🌸 NAME 🌸

DROP_MATERIALIZED_VIEW — remove a materialized view. no cap, that's the whole vibe. 🦋

✨ SYNOPSIS ✨

DROP MATERIALIZED VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

💖 DESCRIPTION 💖

DROP MATERIALIZED VIEW drops an existing materialized view. 🫶

ok but listen: to execute this command you must be the owner of the materialized view. fr fr, owner energy only. 👑

🧚 PARAMETERS 🧚

• IF EXISTS — do not throw an error if the materialized view does not exist. A notice is issued in this case. lowkey polite. 😌
• name — the name (optionally schema-qualified) of the materialized view to remove. yes, schema-qualified is allowed. 💫
• 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). it's giving domino effect. 🔥
• RESTRICT — refuse to drop the materialized view if any objects depend on it. This is the default. protective bestie behavior. 🛡️

🍓 EXAMPLES 🍓

this command will remove the materialized view called order_summary:

DROP MATERIALIZED VIEW order_summary;

slay, gone. 💀✨

🌈 COMPATIBILITY 🌈

DROP MATERIALIZED VIEW is a PostgreSQL extension. iykyk. 🧚

💜 SEE ALSO 💜

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

---

PostgreSQL 13.23 · 2025 · DROP MATE...IZED VIEW(7) — mwah, that's the page, bestie 🎀💖