Skip to main content
Outputs the configuration of an existing data source.
SHOW DATA SOURCE Syntax

​
Parameters

EXTERNAL

Optional keyword for clarity

<schema name>

Name of the schema containing the data source to describe

<data source name>

Name of the data source whose configuration will be output; use * instead of schema/data source name to output the configuration of all data sources

​
Response

The response to DESCRIBE DATA SOURCE is a three-column result set:

​
Examples

To show the configuration for a data source, kin_ds:
DESCRIBE DATA SOURCE Example
To show the configuration for all data sources:
DESCRIBE DATA SOURCE (All Data Sources) Example