Skip to main content
Outputs the DDL statement required to reconstruct the given data source.
SHOW DATA SOURCE Syntax
The PASSWORD value will be masked and would need to be replaced with the actual password if attempting to reconstruct the data source.
The response to SHOW DATA SOURCE 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 source to show

<data source name>

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

​
Examples

To output the DDL for a data source, kin_ds:
SHOW DATA SOURCE Example
To output the DDL for all data sources:
SHOW DATA SOURCE (All Data Sources) Example