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

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

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

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

The `PASSWORD` value will be masked and would need to be replaced with the
actual password if attempting to reconstruct the *data source*.

<Info>
  The response to `SHOW DATA SOURCE` 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 source* to show
  </Accordion>

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

## Examples

To output the DDL for a *data source*, `kin_ds`:

```sql SHOW DATA SOURCE Example theme={null}
SHOW DATA SOURCE kin_ds
```

To output the DDL for all *data sources*:

```sql SHOW DATA SOURCE (All Data Sources) Example theme={null}
SHOW DATA SOURCE *
```