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: