Difference between primary key and unique key ?
- 77 Answers
- 190793 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 / ibrahim
PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
PRIMARY KEY not accepts null values but unique can accept null.
but the core different between primary key and unique is we use primary key to link tow tables with each other but we can not use unique key to do this.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the data pump import utility?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How do I know if oracle is installed on windows?
what is Single Byte Overhead...?
What are the original export and import utilities?
What is the difference between substr & instr functions?
Explain the truncate in oracle?
How to define an anonymous block?
Explain enable novalidate constraint.
Explain the use of analyse option in exp command.
How to create additional tablespaces for an new database?
How to create a server parameter file?
How to insert a record into a table?
What is a user account in oracle?
Difference between pre-select and pre-query
