> ## 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.

# SHOW SCHEMA

Outputs the DDL statement required to reconstruct the given *schema*.

```sql title="SHOW SCHEMA Syntax" theme={null}
SHOW [CREATE] SCHEMA < <schema name> | * >
```

<Info>
  The response to `SHOW SCHEMA` is a single-column result set
  with the DDL statement as the value in the `DDL` column, shown below with
  the column separators returned by <Badge color="blue-destructive">kisql</Badge>.
</Info>

## Parameters

<AccordionGroup>
  <Accordion title="CREATE" id="create" defaultOpen>
    Optional keyword for clarity
  </Accordion>

  <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 `SHOW TABLE` statement instead
  </Accordion>

  <Accordion title="<schema name>" id="<schema-name>" defaultOpen>
    Name of the *schema* whose contained *tables'* & *views'* DDL will be output; use `*` instead
    to output the DDL of all *schemas*, *tables*, & *views*
  </Accordion>
</AccordionGroup>

## Examples

To output the DDL for the example schema created in the
[CREATE SCHEMA](/content/sql/ddl/create-schema#sql-create-schema) section:

```sql SHOW SCHEMA Example theme={null}
SHOW CREATE SCHEMA example_container
```

```sql SHOW SCHEMA Output theme={null}
| CREATE SCHEMA "example_container";   |
```