What is Referential Integrity

Referential Integrity refers that if one table has a Foreign Key column that refers to the Primary Key of another table must include either Null value or the value which matches the value of Primary Key Column.


Foreign Key Column can’t have a value which is not present in Primary Key Column which is referred by the Foreign Key otherwise there will be an inconsistent data in the table. To Restrict this Inconsistency in the Database ,constraint of Referential Integrity comes into play.

referential integrity constraints in dbms,constraints in dbms | key,domain & referential integrity |,Referential Integrity,Referential Integrity Constraints | Database Management System,referential integrity constraint,referential integrity in sql,sql server,referential,integrity,relationships,database,forign,key,reference,column,connection,table,design,constraints,caleb,curry,calebthevideomaker2,