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.

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.


There are no prerequisite tasks.

Verify all keyspaces

Verify that keyspaces exist
cycling_alt            system_schema  dse_leases          dse_perf          
system_virtual_schema  system_auth    system_backups      dse_insights_local
cycling                system_views   dse_insights        dse_system        
dse_security           system         system_distributed
solr_admin             system_traces  dse_system_local  

Verify a single keyspace

Verify that a particular keyspace exists
CREATE KEYSPACE cycling WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'}  AND durable_writes = true;

See also:

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

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,