skip to main content
Using the Driver : Catalog Tables
  

Try DataDirect Drivers Now

Catalog Tables

The Salesforce driver provides a standard set of catalog tables that maintain the information returned by various ODBC catalog functions such as SQLTables, SQLColumns, SQLDescribeParam and SQLDescribeCol. If possible use the ODBC catalog functions to obtain this information instead of querying the catalog tables directly.
The driver also provides additional catalog tables that maintain metadata specific to the Salesforce driver. This section defines the catalog tables that provide Salesforce driver-specific information. The catalog tables are defined in the INFORMATION_SCHEMA schema.
* SYSTEM_CACHES Catalog Table
* SYSTEM_CACHE_REFERENCES Catalog Table
* SYSTEM_REMOTE_SESSIONS Catalog Table
* SYSTEM_SESSIONINFO Catalog Table
* SYSTEM_SESSIONS Catalog Table