Skip to main content
Outputs the DDL statement required to reconstruct one or more existing streams.
SHOW STREAM Syntax
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
The response to SHOW STREAM is a single-column result set with the DDL statement as the value in the DDL column.

​
Parameters

<schema name>

Name of the schema containing the stream(s) to show

<stream name>

Name of the stream to show

​
Examples

To output the DDL for a stream, kin_stream:
SHOW STREAM Example