When used to represent a relationship,the primary key must have the same name as the corresponding foreign key.

Question

Quizplus · Accepted Answer

The primary key and foreign key must have the same data type and the foreign key must refer to the primary key of the related table, but they do not necessarily have to have the same name. However, naming conventions often suggest using the same name for clarity and consistency.

When Used to Represent a Relationship,the Primary Key Must Have