Skip to main content
Outputs a list of tables accessible through a JDBC data source.
LIST DATA SOURCE Syntax
The response to LIST DATA SOURCE is a single-column result set of table names in <schema_name>.<table_name> format.

​
Parameters

DATA SOURCE

Optional keyword for clarity

<schema name>

Name of the schema containing the data source to list

<data source name>

Name of the data source whose accessible tables will be listed

WITH OPTIONS

Optional indicator that a comma-delimited list of filtering option/value assignments will follow. See Options for the full list of options.

​
Examples

To list all the tables accessible through a data source, kin_ds_jdbc:
LIST DATA SOURCE (All Tables) Example
To list all tables in a specific schema:
LIST DATA SOURCE (Filter by Schema) Example
To list tables matching a specific name pattern, regardless of catalog/schema:
LIST DATA SOURCE (Filter by Table) Example

​
Options

The _ and % characters can be used in any of these options to match any single character or any number of characters in object names, respectively. If multiple options are used, the tables must match all specified criteria.

CATALOG

Only show tables within the specified catalog(s)

SCHEMA

Only show tables within the specified schema(s)

TABLE

Only show tables matching the specified name(s)