Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207502 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 / yjreddy
primary key doesnt allow duplicates and null values
unique key allows null value only once
and more over
when you applying primary key by default clustered index is created on that table
when u applying unique key non clustered index is created on that table.
so primary key can be allowed only once(1) and unique u can apply more
than one on a single table(249)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you create a synonym without having a table?
What is the difference between I and G in Oracle?
What is the difference between pre-select and pre-query?
How to load excel data sheet to oracle database
How do you find current date and time in oracle?
List the types of joins used in writing subqueries?
How to create a table index?
Explain the use of parfile option in exp command.
How view is different from a table?
how to handle exceptions in post production
What is a package in oracle?
How to invoke the original export import utilities?
How to connect asp pages to oracle servers?
How can I see all tables in oracle?
What are triggers in oracle?
