sqlcomposite-keycandidate-key

What is the difference between candidate key and composite key?


I am reading about candidate keys and composite keys. I came to know that

For composite key I have referred this link

how do I make a composite key with SQL Server Management Studio?

Thus when both the candidate key and composite key are a combination of columns, they can qualify as a primary key. Then what is the exact difference ? Can you please explain with examples ?


Solution

  • As I know candidate key is a unique key that can be used as a primary key. but not necessarily used as one.

    Composite key is a key of two or more attributes that uniquely identifies the row.