FilterTablesOnDefaultDataset

Default Value	Data Type	Required
`0`	Boolean	No

Description

This option determines whether the connector filters tables in the DatabaseMetaData.getTables call and columns in the DatabaseMetaData.getColumns call to return only tables and columns that belong to the default dataset.

0: The connector returns all tables in the DatabaseMetaData.getTables call and all columns in the DatabaseMetaData.getColumns call.
1: The connector only returns tables and columns that belong to the default dataset.

Note:

To filter tables and columns, you must define a default dataset. For more information, see DefaultDataset.

When this option is set to 1, the connector behaves as described below for the functions DatabaseMetaData.getTables and DatabaseMetaData.getColumns.

For the function DatabaseMetaData.getTables:

Catalog	Schema	Table	Table Type	Returned List
NULL or %	NULL or %	NULL or %	NULL or %	All tables that belong to the default dataset under the default catalog
NULL or %	[schema]	NULL or %	NULL or %	All tables that belong to the specified schema under all catalogs
[catalog]	NULL or %	NULL or %	NULL or %	All tables that belong to the default dataset under the specified catalog
[catalog]	[schema]	NULL or %	NULL or %	All tables that belong to the specified schema under the specified catalog

For the function DatabaseMetaData.getColumns:

Catalog	Schema	Table	Column	Returned List
NULL or %	NULL or %	NULL or %	NULL or %	All columns of all tables that belong to the default dataset under the default catalog
NULL or %	[schema]	NULL or %	NULL or %	All columns of all tables that belong to the specified dataset under all catalogs
[catalog]	NULL or %	NULL or %	NULL or %	All columns of all tables that belong to the default dataset under the specified catalog
[catalog]	[schema]	NULL or %	NULL or %	All columns of all tables that belong to the specified dataset under the specified catalog