Show TOC

Foreign KeysLocate this document in the navigation structure


If the values in a column (or a combination of columns) of a table always match the values of the primary key column of another table, then this column (or combination of columns) is called a foreign key.

Table 1: Foreign Keys


Description (Link to SQL Reference Manual)


Foreign key name

Referencing Columns

Referencing column

Referential CONSTRAINT Definition (referential_constraint_definition)

Reference Schema

Schema to which the table with the column that is referenced belongs

Reference Table

Table to which the column that is referenced belongs

Reference Column

Column which is referenced


Rule for behavior of the table referenced if a data record is deleted in the referencing table

DELETE Rule (delete_rule)

More Information