What is a referential integrity constraint?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is a referential integrity constraint?
Rating:
Referential integrity constraint is a feature in RDBMS (Relational Database Management System) that prevents a user from entering inconsistent data. There are various referential integrity rules that are applied on tables sharing a relationship. These are as follows:
- If the Employee table has a foreign key that is a primary key of the Department table, then the Employee table cannot have a value in the foreign key column if there is no corresponding value in the Department table.
- If a record is deleted from the Department table, the corresponding record must be deleted from the Employee table. This is known as cascading delete.
Rating:
Was this information helpful?
Other articles
- What are stored procedures?
- What is a SQLException?
- What is a foreign key?
- What is 4NF?
- What is a many-to-many relationship?