skip to main content
Using the driver : Catalog Tables : SYSTEM_CACHE_REFERENCES Catalog Table
  

Try DataDirect Drivers Now

SYSTEM_CACHE_REFERENCES Catalog Table

The referenced tables in a relational cache can be determined by querying the SYSTEM_CACHE_REFERENCES system table. This table contains the names of the referenced tables as well as the name of the primary table with which they are associated.
The following table defines the columns of the SYSTEM_CACHE_REFERENCES table, which is sorted on the following columns: TABLE_SCHEMA, TABLE_NAME, and REF_TABLE_NAME.
Table 14. SYSTEM_CACHE_REFERENCES Catalog Table
Column
Data Type
Description
PRIMARY_TABLE_CAT
VARCHAR (128), NULLABLE
The catalog that contains the primary table of the relational cache. It is NULL for the Salesforce driver.
PRIMARY_TABLE_SCHEM
VARCHAR (128), NULLABLE
The schema that contains the primary table of the relational cache.
PRIMARY_TABLE_NAME
VARCHAR (128), NOT NULL
The primary table of the relational cache.
REF_TABLE_NAME
VARCHAR (128), NOT NULL
The name of the referenced table.
RELATIONSHIP_NAME
VARCHAR(128), NOT NULL
The name of the foreign key relationship used to relate this table to the primary table or one of the other tables in the relational cache.