0 votes
in Sql by
What is the difference between primary key and candidate key?

1 Answer

0 votes
by

Every row of a table is identified uniquely by primary key. There is only one primary key for a table.

Primary Key is also a candidate key. By common convention, candidate key can be designated as primary and which can be used for any foreign key references.

...