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

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

Outputs the DDL statement required to reconstruct one or more existing
[streams](/content/sql/ddl/create-stream#sql-create-stream).

```sql title="SHOW STREAM Syntax" theme={null}
SHOW STREAM < [<schema name>.]<stream name> | <schema name>.* | * >
```

Listing options:

* `[<schema name>.]<stream name>` - output the DDL statement of the given
  *stream*
* `<schema name>.*` - output the DDL statements of all *streams* under the
  given *schema*
* `*` - output the DDL statements of all *streams*

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

## Parameters

<AccordionGroup>
  <Accordion title="<schema name>" id="<schema-name>" defaultOpen>
    Name of the *schema* containing the *stream(s)* to show
  </Accordion>

  <Accordion title="<stream name>" id="<stream-name>" defaultOpen>
    Name of the *stream* to show
  </Accordion>
</AccordionGroup>

## Examples

To output the DDL for a *stream*, `kin_stream`:

```sql SHOW STREAM Example theme={null}
SHOW STREAM example.kin_stream
```