Help Center/Data Warehouse Service/SQL Syntax Reference (8.1.3.x)/DDL Syntax/DROP SERVER
Updated on 2025-09-18 GMT+08:00
View PDF

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

Table 1 DROP SERVER parameters

Parameter

Description

Value Range

IF EXISTS

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

-

server_name

Specifies the name of the server to be deleted.

An existing server name.

CASCADE | RESTRICT

Specifies how to process related data in the dependent object when a delete operation is performed.

  • 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 hdfs_server server.

1
DROP SERVER hdfs_server;

Helpful Links

ALTER SERVER, CREATE SERVER

Parent Topic: DDL Syntax