Difference between primary key and unique key ?
- 77 Answers
- 199749 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
Answer Posted / pramod paunikar
Both primary key and unique enforce uniqueness of the
column on which they are defined. But by default primary
key creates a clustered index on the column, where are
unique creates a non-clustered index by default. Another
major difference is that, primary key does not allow NULLs,
but unique key allows only one NULL only.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What is open database communication (odbc) in oracle?
What is recycle bin in Oracle?
How to commit the current transaction in oracle?
How to use fetch statement in a loop?
How to write an inner join with the where clause in oracle?
What are internal user account in oracle?
Write a trigger example in oracle?
How to display row numbers with the records?
How to get execution statistics reports on query statements?
Is there a combination of "like" and "in" in sql?
What is index in Oracle?
How to create a single index for multiple columns?
How to open and close an explicit cursor in oracle?
What is Java Pool in Oracle?
