DROP_FOREIGN_DATA_WRAPPER(7)

💅 DROP_FOREIGN_DATA_WRAPPER 💅

okay bestie, welcome to the DROP_FOREIGN_DATA_WRAPPER(7) page from the PostgreSQL 18.6 Documentation ✨ this is the one where we say bye-bye to a foreign-data wrapper. no cap.

---

✨ NAME ✨

DROP_FOREIGN_DATA_WRAPPER — remove a foreign-data wrapper 🫶 like, yeet it. respectfully.

---

🌸 SYNOPSIS 🌸

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

look at her. she's gorgeous. she's also very literal, so type it exactly bestie 💖

---

🦋 DESCRIPTION 🦋

DROP FOREIGN DATA WRAPPER removes an existing foreign-data wrapper. that's it, that's the whole vibe. 💀

but listen — to execute this command, the current user must be the owner of the foreign-data wrapper. not your friend, not your group chat, you. owner energy only, no borrowing. 👑

---

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the foreign-data wrapper does not exist. instead a notice is issued in this case. so it's giving "no drama, just a little heads up" 🌈
• name — the name of an existing foreign-data wrapper. the actual thing you're dropping, bestie. ✨
• CASCADE — automatically drop objects that depend on the foreign-data wrapper (such as foreign tables and servers), and in turn all objects that depend on those objects (see Section 5.15). this is the dramatic one — it takes the whole friend group down with it. 😭🔥
• RESTRICT — refuse to drop the foreign-data wrapper if any objects depend on it. this is the default. protective, cautious, lowkey the responsible main character. 🧚

---

🍓 EXAMPLES 🍓

drop the foreign-data wrapper dbi:

DROP FOREIGN DATA WRAPPER dbi;

so clean. so simple. ate. 💅

---

👑 COMPATIBILITY 👑

DROP FOREIGN DATA WRAPPER conforms to ISO/IEC 9075-9 (SQL/MED). ⭐ standard behaviour, we love to see it.

the IF EXISTS clause is a PostgreSQL extension. i.e. that part is our little extra, iykyk. 🙈

---

💜 SEE ALSO 💜

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

go read those next, bestie, the trilogy is real 📚✨

---

reminder fr fr: you gotta own the wrapper to drop the wrapper. and RESTRICT is the default, so if stuff depends on it, she will simply refuse. 💀 plan accordingly.

---

and that's the page!! PostgreSQL 18.6, dated 2026 🎀 mwah, thanks for reading bestie, go drop something (a foreign-data wrapper, specifically) 🫶💖