Deletes the definition of a foreign server.

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.

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

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

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

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