1.10 Foreign Keys

Question 1

foreign key

Answer 1

A foreign key is a column, or group of columns, that refer to a primary key.

Question 2

Referential integrity

Answer 2

Referential integrity requires foreign key values must either be NULL or match some value of the referenced primary key.

Question 3

FOREIGN KEY / REFERENCES

Answer 3

A foreign key constraint is added to a CREATE TABLE statement with the FOREIGN KEY and REFERENCES keywords.