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.

DROP SERVER hdfs_server;