> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# DESCRIBE SCHEMA

Lists the contained *tables* and *views* of a given *schema*.

```sql title="DESCRIBE SCHEMA Syntax" theme={null}
DESC[RIBE] [SCHEMA] <schema name>
```

## Parameters

<AccordionGroup>
  <Accordion title="SCHEMA" id="schema" defaultOpen>
    Optional clause to avoid ambiguity; if omitted, and a *table* or *view* exists with the given
    name, the command will be interpreted as a `DESCRIBE TABLE` statement instead
  </Accordion>

  <Accordion title="<schema name>" id="<schema-name>" defaultOpen>
    Name of the *schema* whose contained *tables* & *views* will be listed
  </Accordion>
</AccordionGroup>

## Examples

To describe the tables contained in the `demo` schema, into
which demo data is usually downloaded:

```sql DESCRIBE SCHEMA Example theme={null}
DESC demo
```

```sql DESCRIBE SCHEMA Output theme={null}
+------------+
| Set_name   |
+------------+
| stocks     |
| nyctaxi    |
| flights    |
+------------+
```