DESCRIBE SCHEMA

Shows definitions for all objects in the cluster.

On Linux systems, object names, such as keyspace and table names, are case-sensitive. CQL converts object names to lowercase unless enclosed in double quotation marks.

Synopsis

DESCRIBE [ FULL ] SCHEMA
FULL SCHEMA

Shows definitions for all objects.

SCHEMA

Shows definitions for all non-system objects.

Examples

Shows definitions for all non-system objects:

DESC SCHEMA

This output shows the beginning of the returned results:

CREATE KEYSPACE dse_system_local WITH REPLICATION =
  {'class': 'LocalStrategy'} AND durable_writes = true;

CREATE TABLE dse_system_local.solr_resources (
    core_name text,
    resource_name text,
    resource_value blob,
    PRIMARY KEY (core_name, resource_name)
) WITH CLUSTERING ORDER BY (resource_name ASC)
...

Was this helpful?

Give Feedback

How can we improve the documentation?

© Copyright IBM Corporation 2026 | Privacy policy | Terms of use |  Manage Privacy Choices

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: Contact IBM