What's the difference between a primary key and a unique key?
1)primary key uses clustered index unique key uses non-clustered index 2)primary key doesn't allow null values but unique allows one null value 3)there is only one primary key but more than one unique keys