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
dse_leases    system_schema  cycling_alt         system_traces       dse_system
cycling       system_auth    dse_insights        dse_perf          
dse_security  system         system_distributed  dse_insights_local

Verify a single keyspace

Verify that a particular keyspace exists
DESCRIBE KEYSPACE cycling;
Results
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