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
- foreign-server-name
Specifies the name of the foreign server to be deleted.
- deletion-action::=RESTRICT
- RESTRICT
- If either a foreign table or user mapping is defined in a foreign server definition, the foreign server definition cannot be deleted.
Common rule
- If a foreign server or user mapping is defined on the foreign server, DROP SERVER cannot be executed.
Note
- DROP SERVER cannot be specified from an X/Open compliant UAP running under OLTP.