2.Integrity Concepts
Declarative
Entity integrity
UNIQUE constraints
PRIMARY KEY constraints.
CHECK constraints
Rules
DEFAULT definitions
NOT NULL definitions
Referential integrity
FOREIGN KEY constraints
User-defined integrity
User-defined integrity lets you define specific business rules that do not fall into one of the other integrity categories.
All the integrity categories support user-defined integrity.
This includes all column-level and table-level constraints in CREATE TABLE, stored procedures, and triggers.
Procedural
Implemented through stored procedures, and triggers