DROP_FOREIGN_TABLE(7)

✨ DROP FOREIGN TABLE ✨

okay bestie, we're doing PostgreSQL 18.6 Documentation today and the page is literally called DROP FOREIGN TABLE (that's DROP_FOREIGN_TABLE(7) if you're being formal 💅). it's giving "bye bye, foreign table" energy and honestly? iconic.

---

🌸 NAME 🌸

DROP_FOREIGN_TABLE — remove a foreign table 🦋

---

🎀 SYNOPSIS 🎀

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

---

💖 DESCRIPTION 💖

DROP FOREIGN TABLE removes a foreign table. periodt.

and the tea ☕: only the owner of a foreign table can remove it. so if it's not yours, hands off, bestie 🙈

---

✨ PARAMETERS ✨

• IF EXISTS — don't throw an error if the foreign table doesn't exist. a notice gets issued in this case, which is the polite way of being like "…girl, it was never there 🤷". no cap.
• name — the name (optionally schema-qualified) of the foreign table to drop. so like, schema.table is totally allowed, live your life.
• CASCADE — automatically drop objects that depend on the foreign table (such as views), and in turn all objects that depend on those objects (see Section 5.15). it's the domino effect, fr fr 🁢🁢🁢
• RESTRICT — refuse to drop the foreign table if any objects depend on it. this is the default, so if you don't say anything, it's already being cautious for you. protective king 👑

---

🌈 EXAMPLES 🌈

to destroy two foreign tables, films and distributors:

DROP FOREIGN TABLE films, distributors;

destroy is doing a lot of heavy lifting in that sentence but okay, the docs said it, not me 😭

---

💜 COMPATIBILITY 💜

this command conforms to ISO/IEC 9075-9 (SQL/MED), with two lil exceptions bestie:

• the standard only allows one foreign table to be dropped per command, and
• apart from that, the IF EXISTS option is a PostgreSQL extension. we simply do more ✨

---

🫶 SEE ALSO 🫶

• ALTER FOREIGN TABLE (ALTER_FOREIGN_TABLE(7))
• CREATE FOREIGN TABLE (CREATE_FOREIGN_TABLE(7))

---

and that's the whole page, no notes 💖 this was PostgreSQL 18.6, dated 2026, and yes it really is titled DROP FOREIGN TABLE(7) — go forth and drop responsibly, bestie, and remember: RESTRICT is the default so the database is literally looking out for you 🌸🦋💅