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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.