Question

Difference between primary key and candidate key
​

Answer 1

Answer

Candidate Key – A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table. ... Primary Key – A Primary Key is a column or a combination of columns that uniquely identify a record. Only one Candidate Key can be Primary Key.

Answer 2

Explanation:

Candidate Key – ACandidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table. ... Primary Key – A Primary Key is a column or a combination of columns that uniquely identify a record. Only one Candidate Key can be Primary Key.