Primary Key Vs Unique Key in SQL server

Primary Key Vs. Unique Key in SQL server

 

Primary Key	Unique Key
Primary key doesn’t allow Null values	Unique Key allows Null value. But only one Null value.
By default it create cluster Index	By default it create non cluster index.
Each table has only one primary key	Each table may have more than one unique key. The number of Unique constraints per table limited by no of non-cluster index per table. i.e. 249 for SQL server 2005 999 for SQL Server 2008 and later.
Logically Primary Key is a combination of Unique and NOT NULL Constraints.
Primary key and unique key, both support auto increment value.
Primary key and unique key can be made foreign key into another table.