Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210311 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 happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How to rename an index in oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
WHAT IS ecc 6.0
What is meant by a deadlock situation?
what is meant by magic query
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Explain the use of tables option in exp command.
Why does Oracle not permit the use of PCTUSED with indexes?
What is the difference between substr & instr functions?
various types of hints and their usage
Point out the difference between user tables and data dictionary?
How do I start tns listener?
