Check a keyspace
Use cqlsh to execute the the DESCRIBE KEYSPACES/DESCRIBE KEYSPACE commands.
-
DESCRIBE KEYSPACESlists 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.
Verify all keyspaces
Verify that keyspaces exist
DESCRIBE KEYSPACES;Results
cycling system_auth system_traces
cycling_alt system_distributed system_views
system system_schema system_virtual_schemaVerify a single keyspace
Verify that a particular keyspace exists:
DESCRIBE KEYSPACE cycling;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.
CREATE KEYSPACE cycling WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'} AND durable_writes = true;