DEV Community

Mujahida Joynab
Mujahida Joynab

Posted on

Integrity Constraints

Integrity Constraints
Predefined set of rules that are applied on the table columns / attributes to ensure that the overall validity and consistency of the data present in the database table/relation .

Types of Integrity Constraints

  1. Domain Constraints : It ensures int ID not be Varchar and Varchar Name not be int
  2. Entity Integrity Constraint
    • Primary Key Value can't be null
  3. Relational Integrity Constraint -Specified between two tables . It set rules for relation of two table
  4. Key constraint

Top comments (0)