man > DROP_SERVER(7)

man perldoc info pydoc3 ri search

📛 NAME

DROP_SERVER — remove a foreign server descriptor

🚀 Quick Reference

🎯 Use Case	💻 Command	📝 Description
Drop a server	DROP SERVER foo;	Remove the foreign server named foo
Drop if it exists	DROP SERVER IF EXISTS foo;	No error if the server is missing
Drop with cascading removal	DROP SERVER foo CASCADE;	Also drop dependent objects (e.g., user mappings)
Drop with restrict (default)	DROP SERVER foo RESTRICT;	Refuse if any dependencies exist
Drop multiple servers	DROP SERVER s1, s2;	Remove several servers in one command

📜 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.

⚙️ Parameters

• 💡 IF EXISTS — Do not throw an error if the server does not exist. A notice is issued in this case.
• 🏷️ 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).
• 🚫 RESTRICT — Refuse to drop the server if any objects depend on it. This is the default.

💡 Examples

DROP SERVER IF EXISTS foo;

🌐 Compatibility

DROP SERVER conforms to ISO/IEC 9075-9 (SQL/MED). The IF EXISTS clause is a PostgreSQL extension.

📚 See Also

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

📛 NAME 🚀 Quick Reference 📜 Synopsis 📖 Description ⚙️ Parameters 💡 Examples 🌐 Compatibility 📚 See Also