what is the difference between primary key & foreign key?
- 57 Answers
- 122293 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
Difference between cartesian join and cross join?
How to join two tables in a single query using oracle?
Explain the difference between sap and oracle?
What is recovery manager(rman) backup in Oracle?
how can we store any pdf file in oracle
Describe varray?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How can we create the complete backup of data in the oracle.
How to return top 5 rows in oracle?
How to connect to oracle using service name instead of sid?
How to use "for" statements in oracle?
How to get last row id?
How can we force the database to use the user specified rollback segment?
What is the simplest tool to run commands on oracle servers?
How to add another datafile to a tablespace?
