Are relational integrity and referential integrity the same thing?

777 Views Asked by At

I found the same definition for referential and relational integrity. Are they the same? I have researched the two terms separately but cannot find any good definitions.

1

There are 1 best solutions below

1
On

Yes, they are the same thing. The term "Referential Integrity" is used much more though.

Referential Integrity relates to Foreign Keys in a Relational DB. For a table to exhibit Referential Integrity, the Foreign Key must either be null or reference an existing PK value in the related table.