Remove From My Forums

Primary v Foreign Key

Question
0

Sign in to vote

User2074931137 posted

Can a foreign key be designated that is not a primary ID?

Monday, February 4, 2019 12:50 PM

Answers

0

Sign in to vote
User753101303 posted

Hi,

From https://docs.microsoft.com/en-us/sql/relational-databases/tables/create-foreign-key-relationships?view=sql-server-2017

"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."
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Monday, February 4, 2019 1:12 PM