A unique key allows null value(although only one) but a primary key doesn't allow null values. A table can have more than one unique keys columns while there can be only one primary key. A unique key column creates a non-clustered index whereas the primary key creates a clustered index on the column.