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:

 
Embedded Star Newsletter
Don't have time to visit Embedded Star everyday? Then sign up for our free newsletter. We'll send you an email when we have something to share with you. Your email address will be kept confidential and we will not share, sell, or rent it to anyone. You can unsubscribe at any time by clicking a link in the email.

Enter your email address to sign up for our free newsletter:   

If you are familiar with RSS feeds, you can also sign up for our free blog feed. Our RSS feed is updated in real-time while our newsletter is updated daily.