Resolved: Foreign Key referencing
Can a Foreign Key reference to a Unique Key?
2 answers ( 1 marked as helpful)
Hi Agrim!
Thanks for reaching out.
Yes, a foreign key can reference a unique key in a database. This is because a unique key, like a primary key, ensures that all values in the column are unique, which is a necessary condition for a column to be referenced by a foreign key. The essential requirement for a foreign key is that the column it references must have unique values to maintain referential integrity.
Hope this helps.
Best,
Tsvetelin
Thank you for the reply!