SQL Server, we have two keys which distinctively or uniquely identify a record in the database. Both the keys seems identical, but actually both are different in features and behaviours. In this article, I would like to share the key difference between primary key and unique key. For more help about keys in SQL Server refer the articleDifferent Types of SQL Keys.
Difference between Primary Key & Unique Key
Primary Key
Unique Key
Primary Key can't accept null values.
Unique key can accept only one null value.
By default, Primary key is clustered index and data in the database table is physically organized in the sequence of clustered index.
By default, Unique key is a unique non-clustered index.
We can have only one Primary key in a table.
We can have more than one unique key in a table.
Primary key can be made foreign key into another table.
Unique Constraint can not be related with another table's as a Foreign Key.
CREATE TABLE Employee
(
Emp_ID int PRIMARY KEY,
Emp_Name varchar (50) NOT NULL,
Emp_Sal int UNIQUE,
Location int NULL
)
Liked By
Write Answer
Difference between Primary Key and Unique Key
Join MindStick Community
You have need login or register for voting of answers or question.
Susan White
06-May-2019Thanks for useful answers
Sarah Alfred
30-Apr-2019I am looking for this thanks for sharing it with the community.
Alice Taylor
28-Jan-2019asian fanfics
26-Jan-2019Anonymous User
10-Jan-2019Primary Key:
Unique Key:
Anonymous User
15-Dec-2015SQL Server, we have two keys which distinctively or uniquely identify a record in the database. Both the keys seems identical, but actually both are different in features and behaviours. In this article, I would like to share the key difference between primary key and unique key. For more help about keys in SQL Server refer the article Different Types of SQL Keys.
Unique Constraint can not be related with another table's as a Foreign Key.