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 1. SYSTEM_CACHE_REFERENCES Catalog Table
Column Name Data Type Description
PRIMARY_TABLE_CAT VARCHAR (128), NULLABLE The catalog that contains the primary table of the relational cache. It is NULL for this 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.