What is the difference between the Primary and Foreign key?
- 7 Answers
- 15325 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / dhirendra
Primary Key: This is a constraint which is always unique &
not null.
Foreign Key: This is a constraint which is just opposite to
Primary key. It can be not Null & can accept duplicate value
as well. Foreign key points to same table's primary key or
another table's primary key to make a relationship.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is your daily office routine?
what are wild cards used in database for pattern matching ? : Sql dba
Show the two pl/sql cursor exceptions.
What is a loop in sql?
How is data stored on a disk?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
Does a user_objects view have an entry for a trigger?
Can you inner join the same table?
What are the different sql commands?
How to rename a table?
What is the difference between sql and t sql?
How can I tell if sql is running?
what is a stored procedure? : Sql dba
What is %type in sql?
Is it possible to update views?
