Attribute

UseSessionDatabaseForMetadata (usdm)

Purpose

Specifies whether the driver fetches metadata for only tables in the database to which you are connected when a database name is not specified in metadata calls. When enabled, this option can provide better performance for metadata calls by reducing the number of tables queried.

Valid Values

0 | 1

Behavior

If set to 1 (true), the driver fetches metadata for only tables in the database to which you are connected.

If set to 0 (false), the driver fetches metadata for all tables in all databases.

Notes

  • When the database name is specified in the metadata calls, the driver ignores the value specified for this connection option and returns metadata only for the database specified in the metadata calls.

Default Value

0 (false)