DROP_SERVER(7pg15)

✨ NAME ✨

okay so DROP SERVER — remove a foreign server descriptor. This is the DROP_SERVER(7pg15) page from the PostgreSQL 15.19 Documentation, bestie, and it's literally here to help you drop that descriptor. 💅

🫶 SYNOPSIS 🫶

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

💅 DESCRIPTION 💅

DROP SERVER removes an existing foreign server descriptor. To execute this command, the current user must be the owner of the server. no cap, ownership is the vibe check here. 👑

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the server does not exist. A notice is issued in this case, so it's giving "gentle heads-up" instead of chaos. 🙈
• 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 a whole chain reaction, bestie. 🔥
• RESTRICT — refuse to drop the server if any objects depend on it. This is the default. so if you don't say anything, it's lowkey protective. 🛡️

🌸 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. periodt. ✨

🦋 SEE ALSO 🦋

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

okay bye bestie — this slay little page is from PostgreSQL 15.19, dated 2026. 💅🎀✨