A primary key is a unique column in a database. A candidate key is a set of columns or fields that may be used to uniquely identify a record in a table. A candidate key can work in place of a Primary Key. As a result, a Candidate Key can be used to identify a… Continue reading What is Primary key in sql Server