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.