Elements of a Foreign Key

  • It has the same name as the primary key from which it was copied.

  • It uses a replica of the field specifications for the primary key from which it was copied.

  • It draws its values from the primary key to which it refers.

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.