What is a candidate key

Q

What is a candidate key ?

✍: Guest

A

A table may have more than one combination of columns that could uniquely identify the rows in a table; each combination is a candidate key. During database design you can pick up one of the candidate keys to be the primary key. For example, in the supplier table supplierid and suppliername can be candidate key but you will only pick up supplierid as the primary key.

2007-10-25, 4934👍, 0💬