Difference between Primary Key and Unique key

Computer Engineering Computer Network MCA

Both Primary Key and Unique key are used to get records from tables. These keys are also used to create relationship between tables. Primary Key and Unique key both are used to identify records uniquely in a table. A table can have only one primary key whereas unique keys can be multiple in a single table or relation.

Following are the important differences between Primary Key and Unique key.

Sr. No.	Key	Primary Key	Unique key
1	Definition	Primary Key is used to identify all the records in a relation uniquely.	Unique key is also used to identify a records uniquely.
2	NULL	Primary key can not have null value.	Unique key can accept one null value.
3	Count Wise	Primary key can be only one per table.	Unique key can be multiple in a table.
4	Index	Primary key creats clustered index.	Unique key creates non-clustered index.

Mahesh Parahar

Published on 27-Nov-2019 07:25:18

Related Questions & Answers
Difference between Primary Key and Candidate key
Primary key Vs Unique key
Difference Between Primary and Candidate Key
Difference between Primary key and Foreign key in Database
Difference Between Primary key and Foreign key in DBMS
What is the difference between MySQL PRIMARY KEY and UNIQUE constraint?
Difference between Primary key and Foreign key in SQL Database
Difference between Super Key and Candidate key
Difference between Private Key and Public Key
Remove Primary Key in MySQL?
Reset Primary Key in MySQL
Unique Key in RDBMS
MySQL ALTER column to remove primary key and auto_increment?
How to remove primary key from MongoDB?
How to use Primary Key Constraints and Foreign Key Constraints to enforce database integrity in Oracle?

Previous Page Print Page