Question: what is the difference between unique key and candidate key?
Answer: Candidate Key is a column or combination of columns, which can be a Primary key for the Table. There may be multiple Candidate Keys In a Table. ... Unique Key is a column which has unique value for each row, but it also allow nulls (Primary Key doesn't).