Drop a keyspace

Use the DROP KEYSPACE command to remove a keyspace along with all its data objects and data, such as tables, and any user-defined types, functions, and aggregates contained in the keyspace.

When auto_snapshot is enabled in the cassandra.yaml, the keyspace is automatically backed up on the node where the command is executed. To manually backup the keyspace, see Taking a snapshot.

Prerequisites

A keyspace must exist.

Drop a keyspace and check

Drop the keyspace.
```
DROP KEYSPACE cycling;
```
If you prefer to check the keyspace’s existence before dropping, use:
```
DESCRIBE KEYSPACE cycling;
```

CREATE KEYSPACE cycling WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'}  AND durable_writes = true;

Drop a keyspace

Prerequisites

Drop a keyspace and check

Was this helpful?

Give Feedback