Updated on 2022-07-29 GMT+08:00

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

Delete the hdfs_server server.

1
DROP SERVER hdfs_server;

Helpful Links

CREATE SERVER, ALTER SERVER