Release History
Requirements

Introduction

Quick onboard

Deployment

Data Modeling

Connecting

Write data

Migration

Query

Operations and Maintenance

Performance Tuning

Troubleshooting

Reference Guide

SQL Reference

FAQ

DROP SERVER

Delete the external server descriptor.

Synopsis

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

Description

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