DROP SERVER (Delete a foreign server)

Function

Deletes the definition of a foreign server.

Privileges

Owner of a foreign server definition
This user can delete the definition of his or her own foreign servers.
Users with the DBA privilege
These users can delete the definitions of foreign servers owned by other users.

Format

DROP SERVER foreign-server-name-deletion-action
deletion-action::=RESTRICT

Operands

Common rule

  1. If a foreign server or user mapping is defined on the foreign server, DROP SERVER cannot be executed.

Note

  1. DROP SERVER cannot be specified from an X/Open compliant UAP running under OLTP.