DROP_SERVER(7pg16)

🎀 NAME 🎀

okay so this is DROP_SERVER(7pg16) — the PostgreSQL 16.15 docs page for removing a foreign server descriptor, manual vibes included, and yes bestie you are exactly where you need to be. DROP_SERVER literally means remove a foreign server descriptor. slay.

---

✨ SYNOPSIS ✨

DROP SERVER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

---

💅 DESCRIPTION 💅

DROP SERVER removes an existing foreign server descriptor. no cap, that's the whole main-character move.

To execute this command, the current user must be the owner of the server. fr fr — ownership check is not optional.

---

🌸 PARAMETERS 🌸

• IF EXISTS — Do not throw an error if the server does not exist. A notice is issued in this case. so like, no dramatic error moment, just a little notice 💌
• name — The name of an existing server.
• CASCADE — Automatically drop objects that depend on the server (such as user mappings), and in turn all objects that depend on those objects (see Section 5.14). it's giving chain reaction 💀
• RESTRICT — Refuse to drop the server if any objects depend on it. This is the default. the safe little guardrail is on by default, periodt.

---

🦋 EXAMPLES 🦋

Drop a server foo if it exists:

DROP SERVER IF EXISTS foo;

---

⭐ COMPATIBILITY ⭐

DROP SERVER conforms to ISO/IEC 9075-9 (SQL/MED). The IF EXISTS clause is a PostgreSQL extension. cute little PostgreSQL bonus, iykyk ✨

---

🌈 SEE ALSO 🌈

• CREATE SERVER (CREATE_SERVER(7))
• ALTER SERVER (ALTER_SERVER(7))

go read those too bestie, they're the supporting cast 🫶

bye bestie 💖 this page is from PostgreSQL 16.15, dated 2026 — documentation royalty, periodt 👑✨