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

cycling2          dse_system    dse_insights_local  system_traces        
cycling           dse_leases    system_distributed  dse_security         
system_auth       cycling_alt   system_backups      system_virtual_schema
system_schema     solr_admin    system              system_views         
dse_system_local  dse_insights  dse_perf

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;

Check a keyspace

Prerequisites

Verify all keyspaces

Verify a single keyspace

Was this helpful?

Give Feedback