Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary key & foreign key?
- 57 Answers
- 137401 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohammadazam
A primary key is an combination of attributes that uniquely
identifies each row in a relation. A primary key is
designated by underlining the attribute name. The primary
key of an entity set allows us to distinguish among the
various entities of the set.
A foreign key is an attribute in a relation of database
that serves as the primary key of another relation in the
same database.
| Is This Answer Correct ? | 17 Yes | 6 No |
Answer / khan
i dont know
i just read above
and all answer seems to b same and correct
i am confused
| Is This Answer Correct ? | 30 Yes | 21 No |
Answer / dimna
primay key uniquely identifies records in relation.
in a table only one primary key.But may have more than one
foreign key.
| Is This Answer Correct ? | 17 Yes | 9 No |
Answer / ibrahim
primay key uniquely identifies records in relation.
in a table only one primary key.But may have more than one
foreign key.
| Is This Answer Correct ? | 14 Yes | 7 No |
Answer / navane
Primary key is a keyword.
It should not have null value and duplicate value.
We can have only one primary key in a table and the value
should be unique.
Foreign key is a keyword.
It can have null value and duplicate value.
We can have more than one foreign key for a table and this
froeign key table references the primary key table.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ilakarthi
primary key is available in foreign key but not available in the foreign key for a primary key
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vaziuddin shaik
PRIMARY KEY
-------------
Primary key is a column in a table which is having unique
values......and it does not contain null values and
duplicate values...........
FOREIGN KEY
-------------
Foreign key is a column in a table which act as reference to
another table.....and it may contain null and duplicate
values.....(or)it may not contain null and duplicate
values...........
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sairam
primary key is an individual key
foreign key depends in primary key
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / himabindu
primary key is unique.it does not allow null&duplicate
values.it is individual.
foreign key always refers primary key.it is
independent
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rathika
only one primary key on the table.
more than one foreign key on a table
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the differences between char and nchar in oracle?
How to return top 5 rows in oracle?
How to retrieve data from an cursor to a record?
What is an oracle cursor variable?
How different is ms access and oracle?
What is STATSPACK tool?
How is it different from a normal table?
How to convert character types to numeric types?
How to view all columns in an existing table?
if you ctreate table identity
What is key preserved table?
What are the different type of Segments ?
Oracle General 
