What is the difference between the Primary and Foreign key?
- 7 Answers
- 15322 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 are sql*plus environment variables?
Can we insert data in view?
what tools available for managing mysql server? : Sql dba
How to start oracle sql developer?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What are the three pl sql block types?
What port does sql server use?
What is sql trigger example?
What is the difference between nvl function, ifnull function, and isnull function?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
How do I enable sql encryption?
What are the features of pl sql?
Can we insert data into view?
What does count (*) mean in sql?
Why is theta join required?
