DROP_FOREIGN_DATA_WRAPPER(7pg14)

🦋 DROP_FOREIGN_DATA_WRAPPER(7pg14) 🦋

okay so bestie, welcome to the DROP_FOREIGN_DATA_WRAPPER(7pg14) page from the PostgreSQL 14.24 docs. This is the “remove a foreign-data wrapper” one — yes, the whole page is literally about saying bye to a foreign-data wrapper. It’s giving admin-girlie main character energy, and this page ate and left no crumbs. 💅

🌸 NAME 🌸

DROP_FOREIGN_DATA_WRAPPER — remove a foreign-data wrapper. That’s the name, no cap. 🎀

✨ SYNOPSIS ✨

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

🦋 DESCRIPTION 🦋

So DROP FOREIGN DATA WRAPPER removes an existing foreign-data wrapper. To run this command, the current user must be the owner of the foreign-data wrapper. That ownership thing is not a vibe check you can skip, bestie — it’s literally required. 🔥

🎀 PARAMETERS 🎀

• IF EXISTS — don’t throw an error if the foreign-data wrapper does not exist. A notice is issued in this case. Not me being dramatic, it’s just a notice. 🙈
• name — the name of an existing foreign-data wrapper. You know, the one you’re trying to drop. 💖
• 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.14). This is the “it’s giving chain reaction” option. 🌀
• RESTRICT — refuse to drop the foreign-data wrapper if any objects depend on it. This is the default. So if you don’t pick anything, the command is lowkey saying “bestie, no, something still depends on this.” 💀

🍓 EXAMPLES 🍓

Drop the foreign-data wrapper dbi:

DROP FOREIGN DATA WRAPPER dbi;

💫 COMPATIBILITY 💫

DROP FOREIGN DATA WRAPPER conforms to ISO/IEC 9075-9 (SQL/MED). The IF EXISTS clause is a PostgreSQL extension. So it’s standards-compliant with a lil PostgreSQL-only garnish — slay. ✨

👑 SEE ALSO 👑

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

---

xoxo, bestie 🫶 this was the DROP_FOREIGN_DATA_WRAPPER(7pg14) rewrite, based on the PostgreSQL 14.24 docs and dated 2026 — original footer energy: DROP FOR...A WRAPPER(7). Go drop that foreign-data wrapper, but only if you own it. periodt. 💖🎀