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;
WARNING: cqlsh was built against 5.0-beta1, but this server is 5.0. All features may not work!
CREATE KEYSPACE cycling WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'} AND durable_writes = true;
See also: