Can a foreign key reference a non-primary key which is unique?

Options
- Yes
- No

CORRECT ANSWER : Yes

Discussion Board
Foreign key

Yes, a foreign key can reference a non-primary key which is unique. A FOREIGN KEY constraint does not have to be linked only to a PRIMARY KEY constraint in another table; it can also be defined to reference the columns of a UNIQUE constraint in another table.

Prajakta Pandit 03-1-2017 11:29 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲