• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. SQL Syntax
  6. DROP SERVER

DROP SERVER

Function

DROP SERVER deletes an existing data server.

Precautions

Only the server owner can delete a server.

Syntax

DROP SERVER [ IF EXISTS ] server_name [ {CASCADE | RESTRICT} ] ;

Parameter Description

  • IF EXISTS

    Sends a notice instead of an error if the specified table does not exist.

  • server_name

    Specifies the name of a server.

  • CASCADE | RESTRICT
    • CASCADE: automatically drops objects that depend on the server to be deleted.
    • RESTRICT (default): refuses to delete the server if any objects depend on it.

Examples

See Example in CREATE SERVER.

Helpful Links

CREATE SERVER, ALTER SERVER