What does a FOREIGN KEY constraint enforce?
- A That values are unique across the table
- B That a column value exists in the referenced table's key column
- C That the column cannot be NULL
- D That the column is indexed as primary
Answer
That a column value exists in the referenced table's key column
Foreign keys enforce referential integrity. They require InnoDB and are silently ignored by MyISAM.





