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 ? | 12 Yes | 2 No |
Post New Answer View All Answers
What is a subquery in sql?
Can we write dml inside a function in sql server?
What does := mean in pl sql?
What are the different types of dbms?
Define overloaded procedure?
Which is better cte or subquery?
How do I truncate a word?
Why we use triggers in mysql?
Which language is used in sql?
what is a foreign key ? : Sql dba
what are the limitations of identity column? : Transact sql
How do I remove sql developer from windows 10?
How does sql*loader handles newline characters in a record? : aql loader
When are we going to use truncate and delete?
What is sql resultset?