DROP_FOREIGN_DATA_WRAPPER(7pg13)

💅 DROP_FOREIGN_DATA_WRAPPER — postgresql 13.23 documentation, bestie ✨

okay so real talk, this is the page for DROP_FOREIGN_DATA_WRAPPER from the PostgreSQL 13.23 Documentation, and it's literally the glow-up-and-goodbye command for foreign-data wrappers. let's get into it 🫶

---

✨ NAME ✨

DROP_FOREIGN_DATA_WRAPPER — remove a foreign-data wrapper. that's it, that's the vibe. deleting the thing, no cap 💅

---

🎀 SYNOPSIS 🎀

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

look at her. iconic. one line, so much power ✨

---

🦋 DESCRIPTION 🦋

so DROP FOREIGN DATA WRAPPER removes an existing foreign-data wrapper. that's the whole assignment, and she ate. 🔥

but bestie, listen — to actually execute this command, the current user must be the owner of the foreign-data wrapper. no ownership, no deleting. it's giving main character energy only 🔑

---

🌸 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 like, she just quietly lets you know instead of screaming at you 😭 thoughtful queen
• name — the name of an existing foreign-data wrapper. yk, the thing you're yeeting 🎯
• 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). it's a whole chain reaction, dominoes style 💀 heads up tho, it's a lot
• RESTRICT — refuse to drop the foreign-data wrapper if any objects depend on it. this is the default. she's cautious, she's responsible, we love her 🙈

lowkey important: RESTRICT being the default means postgres is not gonna go deleting your whole dependency tree unless you explicitly say CASCADE. protect your data, bestie 💖

---

🍓 EXAMPLES 🍓

drop the foreign-data wrapper dbi:

DROP FOREIGN DATA WRAPPER dbi;

so clean. so simple. we stan a one-liner 👑

---

🌈 COMPATIBILITY 🌈

DROP FOREIGN DATA WRAPPER conforms to ISO/IEC 9075-9 (SQL/MED). 💯

the IF EXISTS clause is a PostgreSQL extension — that part's a little extra, but like, in a good way ✨

---

💜 SEE ALSO 💜

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

go read those too, iykyk 🧚

---

and that's the page!! 🎀 this was PostgreSQL 13.23, dated 2025, and the header's officially DROP FOR...A WRAPPER(7) (yes the title got truncated, she's mysterious like that 😭). now go forth and drop responsibly, bestie — mwah 💋🌸