In which scenario I can use the unique key and primary key in SQL Server . I mean in real life database how can I judge where I have to use the unique key and primary key.

sunil neha juhi singh

• Jun 28th, 2012

Primary key=not allow null values,create cluster index by default.
unique key=allow only one null values and by default it create non cluster index

kushgudseva

 Profile Answers by kushgudseva Questions by kushgudseva

• May 29th, 2012

A Unique ID and Primary Key Constrain perform the ability to allow unique data in the column but only the Unique constrain allows NULL values in the field along with the unique data. Primary Key constrain fields allow Unique and Not NULL values.

Answer Question  Select Best Answer