Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 137152 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gajendra jain
A table can have only one Primery key but it can have any number of Foreign key.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / anand
Primary key is used to identify a row in a table and it
doesnot allow null values. It avoids duplication of rows.
whereas foreign key refers to a column or combination of
columns included in the defenition of referential integrity
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / 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 |
Answer / leang heng
Primary Key is a column or group of columns that determine
in each Record to make not null.
Foreign Key is Column that provide Relationship to Primary
Key between Entities or Table.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / praneeth
primary key helps in uniquely identifying the records in a table
a foreign key is a field that points to the primary key of another table which links one table to another table
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / aarti
Primary Key : It is a unique key of the table.Unique for
each record in the table(e.g ID).
Foreign Key : When a primary key is used as a reference key
in another table then it is called as a foreign key.It is
used to link two tables.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / keyman
Foreign key = Florida Keys (Keys in a foreign land)
Primary Key = The main key you use to enter you home
| Is This Answer Correct ? | 12 Yes | 36 No |
What is save point in oracle database?
What is a cognitive schema?
What is the difference between postgresql and oracle?
What is self-referential integrity constraint ?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
What is a Private Synonyms ?
Explain the use of online redo log files in oracle.
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,
Why does for update in oracle 8 cause an ora-01002 error?
when loggined as SYSTEM,how to display all the users of database using sql query?
What is the quickest way to export a table to a flat file?
Oracle General 
