What is the difference between the Primary and Foreign key?
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 does an inner join do?
What is data modelling in sql?
What is procedure in pl sql?
Can variables be used in sql statements?
Is like operator in sql case sensitive?
Can delete statement be rollbacked?
How to know the last executed procedure?
What is trigger types in sql?
What is raid? How does it help storage of databases?
What is pl/sql language case sensitive?
What is java sql connection?
How do we accept inputs from user during runtime?
Which join is like an inner join?
What is a trigger word?
Explain the difference between 'between' & 'and' operators in sql