skip to main content
DataDirect Connect Drivers : DB2 Driver : Connection Properties : UseCurrentSchema
  
UseCurrentSchema
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