Check a keyspace

Use cqlsh to execute the the DESCRIBE KEYSPACES/DESCRIBE KEYSPACE commands.

  • DESCRIBE KEYSPACES lists all the current keyspaces.

  • DESCRIBE KEYSPACE <keyspace_name> contains the full details of the keyspace, including all database objects the keyspace contains. The output can be used to recreate a keyspace and all its components.

Verify all keyspaces

Verify that keyspaces exist

DESCRIBE KEYSPACES;
Results
cycling      system_auth         system_traces        
cycling_alt  system_distributed  system_views         
system       system_schema       system_virtual_schema

Verify a single keyspace

Verify that a particular keyspace exists:

DESCRIBE KEYSPACE cycling;

The output includes all settings for tables and other objects including the default settings. To recreate a keyspace in another environment, verify that the keyspace replication factor and datacenter names are compatible.

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

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2025 DataStax, an IBM Company | Privacy policy | Terms of use | Manage Privacy Choices

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com