Document

YMatrix

DROP SERVER

Delete the external server descriptor.

Summary

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

describe

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

Parameters

IF EXISTS

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

servername

The name of the existing server.

CASCADE

Automatically delete server-dependent objects (such as user mapping).

RESTRICT

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

Example

Delete the server named foo (if it exists):

DROP SERVER IF EXISTS foo;

compatibility

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

See also

ALTER SERVER , CREATE SERVER