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.

Prerequisites

There are no prerequisite tasks.

Verify all keyspaces

Verify that keyspaces exist
DESCRIBE KEYSPACES;
Results
WARNING: cqlsh was built against 5.0-beta1, but this server is 5.0.  All features may not work!

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;
Results
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:

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, info@datastax.com