Extended Referential Integrity

Normally, a foreign key in one table references the primary key in another table. In some cases, a foreign key may reference the primary key of the same table. This is known as self-referencing foreign keys. In a related case, the foreign key of one table may reference the primary key of a second table. The second table also has a foreign key, and it references the primary key of the first table. This is known as cross-referencing foreign keys. Cross-referencing and self-referencing foreign keys are a special case of Referential Integrity.

View Entire Paper | Previous Page | White Papers Search

If you found this page useful, bookmark and share it on: