- Data Integrity
- Declarative
- Entity integrity
- UNIQUE constraints
- PRIMARY KEY constraints.
- Domain integrity
- 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
|
|