Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207507 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 / chintan desai
Primary key don't have any null value, each table have only
one primary key. Not support duplicate value.
Unique key is uniquely identify, more then one unique key
allow in table.
Here the main different is what primary key do not have any
null value where unique key have only one null value.
Ex: here t1 is the name of table which have two field id and
name. here id is identify as a unique key then unique key's
null value look like under bellow:
1 chintan
NULL komal
2 ck
NULL NULL
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What happens to indexes if you drop a table?
How to generate query output in html format?
various types of hints and their usage
How to connect to the server with user account: sys?
How to convert characters to times in oracle?
What is Virtual Private Database in Oracle?
How to use attributes of the implicit cursor in oracle?
master table and child table performances and comparisons in Oracle ?
What is an oracle database?
Explain parameter file in oracle.
How to create a table in a specific tablespace?
What does sharding mean?
What is tns service name?
What is the difference between sharding and partitioning?
What is an oracle and why it is used?
