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 keyspace
, you can run either of the following statements:
DESCRIBE KEYSPACE "my_status";
You could also use the following:
DESCRIBE "my_status";
Both of these commands will return the keyspace
schema followed by the schemas of all the tables that are present within the keyspace
schema: