Materialize/doc/user/content/sql/drop-cluster-replica.md

---

title: "DROP CLUSTER REPLICA" description: "DROP CLUSTER REPLICA removes an existing replica for the specified cluster." menu: main:

parent: 'commands'

---

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

{{< tip >}} When getting started with Materialize, we recommend starting with managed clusters. {{</ tip >}}

Syntax

{{< diagram "drop-cluster-replica.svg" >}}

Field	Use
IF EXISTS	Do not return an error if the specified cluster replica does not exist.
_clustername	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.

Examples

SHOW CLUSTER REPLICAS WHERE cluster = 'auction_house';

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

DROP CLUSTER REPLICA auction_house.bigger;

Privileges

The privileges required to execute this statement are:

{{< include-md file="shared-content/sql-command-privileges/drop-cluster-replica.md" >}}

Related pages

• CREATE CLUSTER REPLICA
• SHOW CLUSTER REPLICAS
• DROP OWNED