Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the difference between primary key and candidate key?

user-image
Question added by Julfkar Moh Umar , Sr. Software Engineer , Aakash Edutech Private Limited
Date Posted: 2016/01/14
Jargam Abbas Sayyed Mohammad Azam
by Jargam Abbas Sayyed Mohammad Azam , Senior Software Developer , Trimax Infrastructure Ltd.

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. Each Candidate Key can qualify as Primary Key.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.

More Questions Like This