- It is a column or group of column which can uniquely identify values in the table.
- There might be more than one candidate key in one table.
In case table has multiple Candidate keysa column,
- Which will never going to have Null value and
- Whose values will rarely get changed is chosen.
And we make that column Primary Key?
Now the candidate key columns which are not Primary key are called Alternate keys.
Watch this SQL Server interview question youtube channel