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

<a id="sql-show-catalog" />

Outputs the DDL statement required to reconstruct the given
[catalog](/content/sql/ddl/create-catalog#sql-create-catalog).

```sql title="SHOW CATALOG Syntax" theme={null}
SHOW CATALOG <catalog name>
```

<Info>
  The response to `SHOW CATALOG` is a single-column result set with
  the DDL statement as the value in the `DDL` column.
</Info>

## Parameters

<AccordionGroup>
  <Accordion title="<catalog name>" id="<catalog-name>" defaultOpen>
    Name of the existing *catalog* for which the DDL will be output.
  </Accordion>
</AccordionGroup>

## Examples

To output the DDL for a *catalog*:

```sql SHOW CATALOG Example theme={null}
SHOW CATALOG iceberg_rest_cat
```