English

DROP SERVER

Delete the external server descriptor.

Synopsis

DROP SERVER [ IF EXISTS ] servername [ CASCADE | RESTRICT ]

DROP SERVER deletes existing external server descriptors. The user executing this command must be the owner of the server.

IF EXISTS

If the service does not exist, please do not report an error. In this case, a notification will be issued.

servername

CASCADE

RESTRICT

If any object depends on the server, the server is denied. This is the default value.

Delete the server named foo (if it exists):

DROP SERVER IF EXISTS foo;

DROP SERVER complies with ISO/IEC 9075-9 (SQL/MED). The IF EXISTS clause is a YMatrix database extension.