Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ SQL Reference/ SQL Syntax/ DROP NODE GROUP
Updated on 2025-08-19 GMT+08:00
View PDF

DROP NODE GROUP

Description

Deletes a node group.

Precautions

  • DROP NODE GROUP is an API of the cluster management tool.
  • Only system administrators or a user who has the DROP permission can perform this operation.

Syntax

1
 
DROP NODE GROUP groupname [DISTRIBUTE FROM src_group_name];

Parameters

  • groupname

    Specifies the name of the node group to be dropped.

    Value range: an existing node group name.

  • DISTRIBUTE FROM src_group_name

    If the node group to be dropped originates from the node group specified by src_group_name, set src_group_name to specify the node group to which node information will be synchronized after redistribution. This statement is used only for redistribution after a scale-out. You are advised not to use it, because it may lead to data distribution errors and node group unavailability.

Helpful Links

CREATE NODE GROUP

Parent topic: SQL Syntax