Help Center/ GaussDB/ Developer Guide(Distributed_8.x)/ SQL Reference/ SQL Syntax/ D/ DROP NODE
Updated on 2024-08-20 GMT+08:00
View PDF
Share

DROP NODE

Function

Deletes a node.

Precautions

DROP NODE is an interface of the cluster management tool. You are not advised to use this interface, because doing so affects the cluster. Only the administrator has the permission to use this interface.

Syntax

1
 
DROP NODE [ IF EXISTS ] nodename [WITH ( cnnodename [, ... ] )];

Parameter Description

  • IF EXISTS

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

  • nodename

    Specifies the name of the node to be deleted.

    Value range: an existing node name

  • cnnodename

    Specifies the CN name. If this parameter is defined, the command will be executed on this node in addition to the current connected CN. If it is not specified, DN deletion must be performed on all CNs, and CN deletion must be performed on all CNs except the CN to be deleted.

    Value range: an existing CN name

Examples

See Examples in CREATE NODE.

Helpful Links

Parent topic: D