How to find the list of keyspaces in Cassandra

In this article, we will see how to find the list of keyspaces in Cassandra using different methods.

We can find the list of keyspaces in Apache Cassandra using decribe or running select statement.

How to find the list of keyspaces in Cassandra

1.Find the keyspaces in Cassandra using describe command.

describe keyspaces;

How to find the list of keyspaces in Cassandra

2. Find the list of keyspaces in Apache Cassandra using select statement.

select * from system_schema.keyspaces;

How to rename keyspace in Cassandra

In this article, we will see How to rename keyspace in Cassandra.

How to rename keyspace in Cassandra

Keyspace name cannot be altered in Cassandra. Strategy Name: Strategy name can be altered by using a new strategy name. Replication Factor: Replication factor can be altered by using a new replication factor.

Renaming keyspaces (and column families) is no longer supported, since it was prone to race conditions.