Once you’ve added a foriegn key to a table, you can then create a database constraint that enforces referential integrity between the two tables. This ensures that relationships between tables remain consistent. When one table has a foreign key to another table, the concept of referential integrity states that you may not add a record to the table that contains the foreign key unless there is a corresponding record in the linked table.

Back to Main