Dropping a keyspace

Remove a keyspace and all the database objects it contains.

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

Note: 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.

Tip: Use the OpsCenter Backup Service to back up a keyspace.

Procedure

Drop the keyspace.

DROP KEYSPACE keyspace_name;