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. |
This command requires an existing keyspace.
-
Optional: To check if a keyspace exists before you drop it, use
DESCRIBE KEYSPACE
:DESCRIBE KEYSPACE cycling;
Results
CREATE KEYSPACE cycling WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'} AND durable_writes = true;
-
Drop the keyspace:
DROP KEYSPACE cycling;