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 varchar include?
What is rank dense_rank and partition in sql?
How sql query is executed?
What is a natural join sql?
What is t sql in sql server?
What are the types of triggers in sql?
How do I audit the sql sent to the server?
Is microsoft sql free?
Explain normalization and what are the advantages of it?
What is AUTH_ID and AUTH_USER in pl/sql ?
How can you create an empty table from an existing table?
How can we solve sql error: ora-00904: invalid identifier?
What is a trigger in sql?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
Is natural join and inner join same?