DROP SERVER

Synopsis

Use the DROP SERVER command to remove a foreign server. The user who executes the command must be the owner of the foreign server.

Syntax

drop_server ::= DROP SERVER [ IF EXISTS ] server_name 
                [ CASCADE | RESTRICT ]

drop_server

DROPSERVERIFEXISTSserver_nameCASCADERESTRICT

Semantics

Drop a foreign server named server_name. If it doesn’t exist in the database, an error will be thrown unless the IF EXISTS clause is used.

RESTRICT/CASCADE:

RESTRICT is the default and it will not drop the foreign server if any objects depend on it. CASCADE will drop the foreign server and any objects that transitively depend on it.

Examples

Drop the foreign-data wrapper my_server, along with any objects that depend on it.

yugabyte=# DROP SERVER my_server CASCADE;

See also