Help Center/ GaussDB/ Developer Guide(Centralized_3.x)/ SQL Reference/ SQL Syntax/ DROP SERVER
Updated on 2024-05-07 GMT+08:00
View PDF
Share

DROP SERVER

Description

Drops an existing data server.

Precautions

Only the server owner or a user granted with the DROP permission can run the DROP SERVER command. A system administrator has this permission by default.

Syntax

DROP SERVER [ IF EXISTS ] server_name [ { CASCADE | RESTRICT } ] ;

Parameters

  • IF EXISTS

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

  • server_name

    Specifies the name of the data server to be dropped.

  • CASCADE | RESTRICT

    • CASCADE: automatically deletes the objects that depend on the data server.

    • RESTRICT: refuses to delete the server if any objects depend on it. This is the default action.

Helpful Links

ALTER SERVER and CREATE SERVER

Parent topic: SQL Syntax