Learning Apache Cassandra - Second Edition

Viewing a keyspace schema

Suppose we lost a local copy of the schema we created and wish to retrieve the schema from Cassandra. In such situations, we can use the cqlsh functions to fetch the keyspace schema as well as the schema of any particular table. To get a list of keyspaces that were created on the local node within Cassandra, we can simply run the following statement:

DESCRIBE KEYSPACES;

This will return the list of keyspaces. This also contains several system keyspaces, which are used by Cassandra for internal purposes. As we can see, this will also contain the my_status keyspace we created:

To view the schema of a particular