affiliate_link

Wednesday, May 6, 2009

What is Referential Integrity?

Referential integrity is a database concept that 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. It also includes the techniques known as cascading update and cascading delete, which ensure that changes made to the linked table are reflected in the primary table.

Reference: http://databases.about.com/cs/administration/g/refintegrity.htm