DROP_FOREIGN_DATA_WRAPPER(7pg17)

💅 DROP FOREIGN DATA WRAPPER 💅

Okay bestie, welcome to the DROP_FOREIGN_DATA_WRAPPER page — that's the 7pg17 one, from the PostgreSQL 17.11 docs. Buckle up, this one's short and sweet, and honestly? Ate. ✨

---

🌸 NAME 🌸

DROP_FOREIGN_DATA_WRAPPER — literally just removes a foreign-data wrapper. That's the whole vibe. 🫶

---

🎀 SYNOPSIS 🎀

DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

---

✨ DESCRIPTION ✨

So DROP FOREIGN DATA WRAPPER removes an existing foreign-data wrapper. Simple. Iconic. No notes. 💅

But listen — vibe check first: to actually run this command, the current user has to be the owner of the foreign-data wrapper. Not your friend, not your cousin, you. Own it or don't run it, periodt. 👑

---

🔥 PARAMETERS 🔥

• IF EXISTS — do not throw an error if the foreign-data wrapper doesn't exist. Instead it just issues a notice. So chill. So forgiving. 🕊️
• name — the name of an existing foreign-data wrapper. That's the one you're yeeting.
• CASCADE — automatically drops objects that depend on the foreign-data wrapper (think foreign tables and servers, bestie), and then in turn all the objects that depend on those objects. It's giving domino effect. See Section 5.15 for the full tea. 😭🔥
• RESTRICT — refuses to drop the foreign-data wrapper if any objects depend on it. Safe, careful, lowkey the responsible one. This is the default. 🎀

Heads up: CASCADE goes deep — it chains through everything depending on the dependents. Know what you're dropping before you drop it, fr fr. 💀

---

🦋 EXAMPLES 🦋

Wanna drop the foreign-data wrapper named dbi? Say less:

DROP FOREIGN DATA WRAPPER dbi;

---

🌈 COMPATIBILITY 🌈

DROP FOREIGN DATA WRAPPER conforms to ISO/IEC 9075-9 (SQL/MED) — certified standard behavior, we love that for us. 💖

The IF EXISTS clause though? That's a PostgreSQL extension. Homegrown. Main character energy. ✨

---

👑 SEE ALSO 👑

• CREATE FOREIGN DATA WRAPPER (CREATE_FOREIGN_DATA_WRAPPER(7))
• ALTER FOREIGN DATA WRAPPER (ALTER_FOREIGN_DATA_WRAPPER(7))

---

And that's the whole page, bestie — no cap, every single detail preserved. 🧚 Mwah! 💜

PostgreSQL 17.11 · 2026 · DROP FOREIGN DATA WRAPPER(7) — catch you in the next manpage, ily, bye! 🍓⭐