Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 135098 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / abhishek ranjan
The main diference between primary key and the foreign key is that the primary key is a column or a set of columns that can be used to uniquely identify a row in a table while the foreign key is a column or a set of columns that refer to a primary key or a candidate key of another table. Foreign key mainly provides a method to link information in several tables. Another difference is that a table can have a single primary key, but it can have multiple foreign keys that can reference different tables.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
how to handle exceptions in post production
 What are the oracle DML commands possible through an update strategy?
Can we write insert statement in function in oracle?
What are internal user account in oracle?
How to do clean up if create database failed?
What is the difference between formal parameters and actual parameters?
What is primefaces used for?
what is the difference between restoring and recovering?
What is ceil and floor in oracle?
How to use like conditions in oracle?
Will you be able to store pictures in the database?explain.
How different is ms access and oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Is there an oracle sql query that aggregates multiple rows into one row?
How to pass parameters to procedures in oracle?
