Referencing Clause Purpose The Referencing clause specifies the name of the remote table(s) for which a relationship cache is to be created; it is optional. The specified remote table must be related to either the primary table being cached or one of the other specified related tables. The remote table name cannot include a schema name. The referenced tables must exist in the same schema as the primary table. Syntax REFERENCING (remote_table_ref[,remote_table_ref]...)] where: remote_table_ref Represents remote_table[.foreign_key_name] remote_table Specifies one or more tables related to the primary table that are to be cached in conjunction with the primary table. foreign_key_name Specifies the name of the foreign key relationship between the remote table and the primary table (or, optionally, another related table). If a foreign key name is not specified, the driver attempts to find a relationship between the remote table and one of the other tables specified in the relational cache. The driver first looks for a relationship to the primary table. If a relationship to the primary table does not exist, the driver then looks for a relationship to other referenced tables.