Integrity Constraints

Integrity constraints are the constraints defined on base tables in order to ensure the data integrity in a database. Integrity constraints could either be a specification of uniqueness for values of a column, validation for values of a column, or referential integrity constraints.

Referential integrity ensures that the relationships among different rows of the same or different tables are valid. For example, the referential integrity ensures that a master row is inserted before a detail row and a detail row is deleted before the master row.