LIST_JDBC_DATASOURCE_TABLES

Description

The stored procedure LIST_JDBC_DATASOURCE_TABLES returns the tables and views on the underlying database of a JDBC data source.

You can create base views over the tables/views returned by this procedure, using the procedure GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW.

Syntax

LIST_JDBC_DATASOURCE_TABLES (
    data_source_name : text
)
  • data_source_name: name of the data source for which you would like to get the list of tables.

The procedure returns one row for each table in the JDBC data source:

  • catalog_name: name of catalog of given table.
  • schema_name: name of schema of given table.
  • table_name: name of given table.
  • type: type of catalog of given table. The possible values are TABLE and VIEW.

Privileges Required

The user must have execute privileges over the data source in question.