Clever Geek Handbook

Are relational integrity and referential integrity the same?

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

+1


source to share


1 answer


Yes, they are the same thing. However, the term referential integrity is used much more.



Referential integrity refers to foreign keys in a relational database. For a table to display referential integrity, the foreign key must be null or reference an existing PK value in the linked table.

+1


source






More articles:


All Articles