> ## 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 DATA SINK

<a id="sql-show-data-sink" />

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

```sql title="SHOW DATA SINK Syntax" theme={null}
SHOW [EXTERNAL] DATA SINK < [<schema name>.]<data sink name> | * >
```

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

## Parameters

<AccordionGroup>
  <Accordion title="EXTERNAL" id="external" defaultOpen>
    Optional keyword for clarity
  </Accordion>

  <Accordion title="<schema name>" id="<schema-name>" defaultOpen>
    Name of the *schema* containing the *data sink* to show
  </Accordion>

  <Accordion title="<data sink name>" id="<data-sink-name>" defaultOpen>
    Name of the *data sink* for which the DDL will be output; use `*` instead of
    *schema*/*data sink* name to output the DDL of all *data sinks*
  </Accordion>
</AccordionGroup>

## Examples

To output the DDL for a *data sink*, `kin_dsink`:

```sql SHOW DATA SINK Example theme={null}
SHOW DATA SINK kin_dsink
```

To output the DDL for all *data sinks*:

```sql SHOW DATA SINK (All Data Sinks) Example theme={null}
SHOW DATA SINK *
```