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.

Related questions

0 votes
asked Jan 13 in Sql by DavidAnderson
0 votes
asked Jan 14 in Sql by AdilsonLima
...