DROP_MATERIALIZED_VIEW(7pg14)

💅 DROP MATERIALIZED VIEW 💅

okay bestie, welcome to the DROP MATERIALIZED VIEW page — section 7, from the PostgreSQL 14.24 Documentation — and it's literally the manual for removing an existing materialized view from your database. no cap, this is the main-character cleanup command ✨.

✨ NAME ✨

DROP_MATERIALIZED_VIEW — remove a materialized view. that's it, that's the name, and it's giving “bye-bye, materialized view” 💖.

🌸 SYNOPSIS 🌸

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

🫶 DESCRIPTION 🫶

DROP MATERIALIZED VIEW drops an existing materialized view. simple. iconic.

but bestie, the owner check is real: to execute this command you must be the owner of the materialized view. no owner energy, no drop energy 💅.

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the materialized view does not exist. a notice is issued in this case. so it's like “we checked, she's not here, moving on” 📝.
• name — the name (optionally schema-qualified) of the materialized view to remove. yes, schema-qualified is allowed, iykyk 🧚.
• 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). this is the “and everything that came with her” option, lowkey a lot 🌀.
• RESTRICT — refuse to drop the materialized view if any objects depend on it. this is the default. so if you don't say CASCADE, it's gonna be protective and say “nope, she has dependents” 🛑.

🍓 EXAMPLES 🍓

this command will remove the materialized view called order_summary:

DROP MATERIALIZED VIEW order_summary;

slay. clean. done 💖.

🌈 COMPATIBILITY 🌈

DROP MATERIALIZED VIEW is a PostgreSQL extension. periodt.

🦋 SEE ALSO 🦋

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

---

mwah 💋 this cute little sign-off is brought to you by PostgreSQL 14.24, dated 2026, and yes, it's still the DROP MATERIALIZED VIEW(7) manual page. bye bestie, go drop responsibly 🫶✨