Difference between candidate key, unique key and primary key
What is the difference between candidate key, unique key and primary key ?
Â
Candidate keys are the columns in the table that could be the primary keys and the primary key is the key that has been selected to identify the rows. Unique key is also useful for identifying the distinct rows in the table.)