Ankit
Reputation: 639
In what situation would I be forced to use primary key or a unique key?
I've googled about the differences between pk and uk. I've read QA on stackoverflow regarding the pk and uk.
Can please anyone in simple terms briefly tell me in what situation would i be preferring pk over uk or vice -versa.
Regards, Ankit
Upvotes: 0
Views: 99
Answers (1)
whywake
Reputation: 910
If your column has all the distinct values and all not null values, use primary key and if it can insert only one null value along with all other distinct values, consider using unique key.
Upvotes: 1
Related Questions
- What is the difference between a primary key and a unique constraint?
- Difference between primary key and unique key
- Why we need a primary key?
- How is primary key is different from unique key when both are actually serving the same purpose as per my understanding?
- What is the use of primary key when non unique values can be entered in the database?
- What are the main differences between a primary key and a unique constraint?
- SQL: What is does the UNIQUE mean when creating a primary key
- When is it proper to use unique key in a table than a primary key?
- Do you need a primary key if duplicates are allowed?
- SQL Primary Key