Ashwini`s TechNet

2.Integrity Concepts

Data Integrity
1. Declarative
  1. Entity integrity
    1. UNIQUE constraints
    2. PRIMARY KEY constraints.
  2. Domain integrity

- - 1. CHECK constraints
    2. Rules
    3. DEFAULT definitions
    4. NOT NULL definitions

1. 1. Referential integrity

- - 1. FOREIGN KEY constraints

1. 1. User-defined integrity

- - 1. User-defined integrity lets you define specific business rules that do not fall into one of the other integrity categories.
    2. All the integrity categories support user-defined integrity.
    3. This includes all column-level and table-level constraints in CREATE TABLE, stored procedures, and triggers.

1. Procedural

- 1. Implemented through stored procedures, and triggers

Page updated

Google Sites

Report abuse