2.11 Referential Integrity

0.0(0)

Studied by 0 people

Learn

Practice Test

Spaced Repetition

Match

Flashcards

Card Sorting

1/3

Looks like no tags are added yet.

Study Analytics

Name	Mastery	Learn	Test	Matching	Spaced

No study sessions yet.

1

New cards

fully NULL

foreign key is a simple or composite foreign key in which all columns are NULL.

2

New cards

Referential integrity

is a relational rule that requires foreign key values are either NULL or match primary key value.

3

New cards

RESTRICT

rejects an insert, update, or delete that violates referential integrity.

4

New cards

CASCADE

propagates primary key changes to foreign keys.
If a primary key is deleted, rows containing matching foreign keys are deleted. If a primary key is updated, matching foreign keys are updated to the same value.
RESTRICT, SET NULL, and SET DEFAULT apply to primary key update and delete, and foreign key insert and update.
applies to primary key update and delete only.