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_alt system_schema dse_leases dse_perf
system_virtual_schema system_auth system_backups dse_insights_local
cycling system_views dse_insights dse_system
dse_security system system_distributed
solr_admin system_traces dse_system_local Verify 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;