Although both Primary key and Unique Key enforces uniqueness on the columns on which they are defined.There are some similarities between them which are as follows:-
-> Primary key and unique Key columns allow only unique values.
-> Primary key and unique Key columns will always avoid duplicates.
-> Both Primary key and unique Key columns uniquely identifies each Row or Record in the table they are defined.
Asked In: Many Interviews |