Keeping this in view, what do you mean by referential integrity?
Referential integrity requires that a foreign key must have a matching primary key or it must be null. This constraint is specified between two tables (parent and child); it maintains the correspondence between rows in these tables. It means the reference from a row in one table to another table must be valid.
Also Know, which table type is used for referential integrity? InnoDB table type
Similarly one may ask, what is referential integrity and how can we achieve it?
Referential integrity refers to the accuracy and consistency of data within a relationship. In relationships, data is linked between two or more tables. This is achieved by having the foreign key (in the associated table) reference a primary key value (in the primary – or parent – table).
What happens if referential integrity is not enforced?
If you do not code the referential constraints, then your DBMS will permit you to do improper things such as backing up related tables on different schedules. That means data integrity issues can arise if you have to recover using the backups without applying log records.
