What is referential integrity

440 Views 7 Replies 4 Participants Last post by 98uk, Nov 26, 2009

hurrp

Discussion Starter · Nov 25, 2009

Is it just making sure that the primary key field is the same in the Foriegn key field?

Save

1 - 8 of 8 Posts

TwoCables

· #2 · Nov 25, 2009

Quote:

Originally Posted by hurrp

Is it just making sure that the primary key field is the same in the Foriegn key field?

I just happened to fine this, so I'm curious: is this what you're looking for? http://en.wikipedia.org/wiki/Referential_integrity

If not, then I would guess that you're looking for somebody to answer this in their own words. Unfortunately, I don't know what Referential Integrity is even after reading the Wikipedia article.

See less See more

Save

Coma

· #3 · Nov 25, 2009

The explanation on the page of this image explains it best:
http://en.wikipedia.org/wiki/File:Re...ity_broken.PNG

Save

hurrp

Discussion Starter · #4 · Nov 25, 2009

Ive read it already but I still dont understand it ;/

Save

TwoCables

· #5 · Nov 25, 2009

Quote:

Originally Posted by hurrp

Ive read it already but I still dont understand it ;/

I suspected that. So, I'm replying in order to bump this again in hopes that somebody can just explain it in their own words.

See less See more

Save

Coma

· #6 · Nov 25, 2009

Have you read the one on the PNG page? That explanation is much better.

Save

hurrp

Discussion Starter · #7 · Nov 26, 2009

yeah i read it, i kind of get it but i just dont understand it in the way its written on wikipedia

Save

98uk

· #8 · Nov 26, 2009

Where data in one table must match data in another table.

So, if you change say User_ID in a members table, it changes the User_ID in the Orders table.

Save

1 - 8 of 8 Posts

This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.

Top Contributors this Month