- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Difference between Primary Key and Unique key
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. |
Updated on 27-Nov-2019 07:25:54
- 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
- What is the difference between Symmetric Key Cryptographic and Asymmetric Key Cryptography?
- Unique Key in RDBMS
- MySQL ALTER column to remove primary key and auto_increment?
- How to remove primary key from MongoDB?
Advertisements