Updated on 2025-02-27 GMT+08:00

DROP NODE

Description

Drops a node.

Precautions

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

Syntax

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

Parameters

  • 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 dropped.

    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 dropped.

    Value range: an existing CN name.

Helpful Links

CREATE NODE and ALTER NODE