Keyspace, table, and column information
Querying system.schema_keyspaces directly.
Procedure
Query the defined keyspaces using the SELECT statement.
SELECT * FROM system.schema_keyspaces;
The cqlsh output includes information about defined keyspaces.
keyspace | durable_writes | name | strategy_class | strategy_options ----------+----------------+---------+----------------+---------------------------- history | True | history | SimpleStrategy | {"replication_factor":"1"} ks_info | True | ks_info | SimpleStrategy | {"replication_factor":"1"}