DROP_MATERIALIZED_VIEW(7pg18)

✨ DROP_MATERIALIZED_VIEW 💅

okay so bestie, welcome to the PostgreSQL 18.6 docs, page DROP_MATERIALIZED_VIEW(7) — yes the man page name is literally DROP MATE...IZED VIEW(7) when your terminal is too narrow, she's iconic like that 🎀

---

🌸 NAME 🌸

DROP_MATERIALIZED_VIEW — bestie, this is the one that removes a materialized view. poof. gone. no cap 💨

---

🦋 SYNOPSIS 🦋

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

look at her. short. powerful. main character energy fr fr 👑

---

💖 DESCRIPTION 💖

So DROP MATERIALIZED VIEW drops an existing materialized view. that's the whole vibe.

but the tea ☕ — to run this command you MUST be the owner of the materialized view. not your friend, not your coworker, you. own it or don't drop it, periodt.

---

🎀 PARAMETERS 🎀

• IF EXISTS — pls don't throw an error if the materialized view doesn't exist, we're being chill about it. a notice gets issued instead, so you still get a lil heads up 🫶
• name — the name of the materialized view you wanna remove. optionally schema-qualified, so you can be all myschema.myview about it if you want to be specific 💅
• CASCADE — okay so this one goes feral 😭 it automatically drops objects that depend on the materialized view (like other materialized views, or regular views), and then in turn all the objects that depend on those objects. it's a whole chain reaction, see Section 5.15. use with intention bestie, she does not stop at one 🔥
• RESTRICT — the safe queen 👑 she refuses to drop the materialized view if any objects depend on it. this is the default, so if you don't say anything, you get the cautious behavior. no accidental chaos. we love a boundary.

---

🌈 EXAMPLES 🌈

this command will remove the materialized view called order_summary:

DROP MATERIALIZED VIEW order_summary;

ate. that's it. that's the whole thing ✨

---

💜 COMPATIBILITY 💜

DROP MATERIALIZED VIEW is a PostgreSQL extension. so like, she's ours, she's special, other databases don't have this exact move. iykyk 💫

---

🍓 SEE ALSO 🍓

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

go read those too, the whole materialized view cinematic universe is worth your time 🦋

---

⚠️ real talk bestie: CASCADE is not a joke. it will take the whole friend group down with it. if you're not sure, let RESTRICT (the default!) hold your hand 🫶

---

and that's the page!! brought to you by PostgreSQL 18.6, dated 2026, filed under DROP MATE...IZED VIEW(7) 💖 mwah, go drop responsibly, ily 🎀✨