DROP_VIEW(7pg18)

💅 NAME 💅

DROP_VIEW — bestie, it's how you remove a view. That's it. That's the whole job. ✨

---

🎀 SYNOPSIS 🎀

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

---

🦋 DESCRIPTION 🦋

Okay so DROP VIEW drops an existing view. Simple, clean, iconic. 🌸

But listen — there's a whole vibe check you have to pass first: to execute this command you must be the owner of the view. Not a friend of the owner. Not someone who once saw the view in a group chat. The owner. Periodt. 👑

---

✨ PARAMETERS ✨

• IF EXISTS — the "no drama please" flag 💖. If the view doesn't exist, don't throw an error. Instead, a notice gets issued. So like, it still tells you, just gently. 🫶
• name — the name of the view to remove, and yes it can be optionally schema-qualified. So myschema.myview is valid, go off. 🎀
• CASCADE — the "and take everyone with it" option 😭🔥. This automatically drops objects that depend on the view (like other views, bestie, it's giving dominoes 🁢🁢🁢), and in turn all objects that depend on those objects. See Section 5.15 for the full lore.
• RESTRICT — the "actually no, don't" option 💅. This refuses to drop the view if any objects depend on it. This is the default, so if you don't say anything, the cautious girlie behavior is what you get. No accidental mass deletion energy here. 🙈

⚠️ Heads up bestie: CASCADE is not playing. It chains. Views on views on views. Make sure you know what's downstream before you send it. 💀

---

🌈 EXAMPLES 🌈

This command will remove the view called kinds:

DROP VIEW kinds;

Clean. One line. Slayed. ✨

---

💜 COMPATIBILITY 💜

So this command conforms to the SQL standard — mostly. Two little asterisks, bestie:

• The standard only allows one view to be dropped per command. PostgreSQL said "what if we let you do a bunch," because why not. 👑
• Apart from the IF EXISTS option, which is a PostgreSQL extension — the standard didn't think of it, we did. 🎀

---

🌸 SEE ALSO 🌸

• ALTER VIEW (ALTER_VIEW(7))
• CREATE VIEW (CREATE_VIEW(7))

---

okay that's the whole page bestie, go forth and drop responsibly 💖✨

this was PostgreSQL 18.6 documentation, dated 2026 — ty for coming to my TED talk, mwah 🎀🦋💅