CQL shell commands
CQL shell or cqlsh
comes with many little utilities. In this section, we will see them.
DESCRIBE
The DESCRIBE
command is used to get details of container objects. You can use DESC
in place of DESCRIBE
. So, one can describe a keyspace, table, or cluster. There are five variants of this command:
# Describe the whole cluster DESCRIBE CLUSTER # Display the CQL command to regenerate all the keyspaces in the cluster DESCRIBE SCHEMA # List all the keyspaces names DESCRIBE KEYSPACES # List the CQL statement that can be used to recreate the keyspace DESCRIBE KEYSPACE <keyspace_name> # Show tables names in the current keyspace # Show all the tables across all the keyspaces if not using any keyspace DESCRIBE TABLES # Print CQL to create ...
Get Mastering Apache Cassandra - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.