DROP CLUSTER REPLICA

WARNING!

DROP CLUSTER REPLICA is deprecated.

We recommend migrating to a managed cluster instead of manually creating and dropping replicas.

DROP CLUSTER REPLICA deprovisions an existing replica of the specified cluster. To remove the cluster itself, use the DROP CLUSTER command.

Syntax

Field	Use
IF EXISTS	Do not return an error if the specified cluster replica does not exist.
cluster_name	The cluster you want to remove a replica from. For available clusters, see `SHOW CLUSTERS`.
replica_name	The cluster replica you want to drop. For available cluster replicas, see `SHOW CLUSTER REPLICAS`.

SHOW CLUSTER REPLICAS WHERE cluster = 'auction_house';

    cluster    | replica
---------------+---------
 auction_house | bigger

DROP CLUSTER REPLICA auction_house.bigger;

The privileges required to execute this statement are: