DROP SERVER

Function

DROP SERVER deletes an existing data server.

Precautions

Only the server owner can delete a server.

Syntax

1

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