Question: what is the difference between a primary key and unique index?
Answer: Key Differences Between Primary key and Unique key: Primary key will not accept NULL values whereas Unique key can accept one NULL value. ... A Clustered index automatically created when a primary key is defined whereas Unique key generates the non-clustered index.