What is the difference between the Primary and Foreign key?
- 7 Answers
- 14301 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 ? | 12 Yes | 2 No |
Post New Answer View All Answers
What is the difference between truncate and drop statements?
How do I enable sql encryption?
How do you write a subquery?
explain normalization concept? : Sql dba
what is a unique key ? : Sql dba
what is data manipulation language? : Sql dba
what are local and global variables and their differences? : Sql dba
What is the source code of a program?
what are all different types of collation sensitivity? : Sql dba
What is a variable in sql?
Does execute immediate commit?
what are the different tables present in mysql? : Sql dba
explain what is mysql? : Sql dba
What is sql architecture?
What are the properties of a transaction?
