Skip to main content
Outputs the DDL statement required to reconstruct the given data sink.
SHOW DATA SINK Syntax
The response to SHOW DATA SINK is a single-column result set with the DDL statement as the value in the DDL column.

​
Parameters

EXTERNAL

Optional keyword for clarity

<schema name>

Name of the schema containing the data sink to show

<data sink name>

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

​
Examples

To output the DDL for a data sink, kin_dsink:
SHOW DATA SINK Example
To output the DDL for all data sinks:
SHOW DATA SINK (All Data Sinks) Example