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.
Property |
Description (Link to SQL Reference Manual) |
---|---|
Name |
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 |
Rule for behavior of the table referenced if a data record is deleted in the referencing table |
SQL Reference Manual, Referential CONSTRAINT Definition
SQL Tutorial, Foreign Key Relationships Between Tables
Database Studio, Defining Foreign Key Relationships