Purpose

Specifies whether results are restricted to the tables and views in the current schema if a DatabaseMetaData.getTables() or DatabaseMetaData.getColumns() method is called without specifying a schema or if the schema is specified as the wildcard character %. Restricting results to the tables and views in the current schema improves the performance of calls for getTables() methods that do not specify a schema.

Valid Values

true | false

Behavior

If set to true, results that are returned from the getTables() and getColumns() methods are restricted to tables and views in the current schema.

If set to false, results of the getTables() and getColumns() methods are not restricted.

Default

false

Data Type

boolean

See also

Performance Considerations