Referential integrity is a data base concept indicating consistency between coupled tables. Referential integrity is enforced by the combination of a primary key and a foreign key. Within the data base design these keys are based upon the concept of ID fields.
For referential integrity to hold, any field in a table that is declared a foreign key can contain only values from a parent table's primary key or a candidate key. For instance, deleting a record that contains a value referred to by a foreign key in another table would break referential integrity.
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation