Help Center> Data Warehouse Service> SQL Syntax Reference> DDL Syntax> DROP SERVER
View PDF

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 Examples in CREATE SERVER.

Helpful Links

CREATE SERVER, ALTER SERVER

Parent topic: DDL Syntax