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 is the difference between functions, procedures, and packages in pl/sql?
What are the different types of tables in sql?
What is mdb stand for?
What is row_number () in sql?
How to select unique records from a table?
What is percent sign in sql?
How can you know that statistics should be updated?
what is innodb? : Sql dba
Write a sql select query that only returns each name only once from a table?
Which data type is a composite type?
What is forward declaration in pl sql?
what are aggregate and scalar functions? : Sql dba
How many types of cursors are available in pl/sql?
What is equi join in sql?
What is primary key and foreign key?