Integrity Constraints in SQL Server – SQL Server Tutorial

INTEGRITY CONSTRAINTS    :-     

  • Business rules can be implemented in two ways  :
  1. Declarative Approach
  2. Procedural Approach
  • Declarative using integrity constraints
  • Procedural using database triggers.
  • If business rules are simple,then they com be implemented by using Integrity constraints.
  • If business rules are complex, then the database-triggers.
  • Integrity constraints used to : implement the business rule and Used to validate data.
  • An integrity constraint ensures data integrity.

Integrity constraints are 3 types  :-

  1. Entity integrity
  2. Domain integrity
  3. Referential integrity

Leave a Reply

Your email address will not be published. Required fields are marked *