What is the difference between the Primary and Foreign key?

Answer Posted / suma

Primary key is unique index and non null coulum in a table.
While foreign key can have repeated values.

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is theta join required?

662


Why is there a need for sqlcode and sqlerrm variables?

585


What is procedure and function?

516


What is the left table in sql?

517


What are the two different parts of the pl/sql packages?

559






What is a unique key?

586


Is pl sql and postgresql same?

571


what are the 'mysql' command line arguments? : Sql dba

650


what are all the different types of indexes? : Sql dba

526


How many row comparison operators are used while working with a subquery?

535


How do I count records in sql?

514


What is the use of non clustered index?

526


Write the command to remove all players named sachin from the players table.

738


Is it important to partition hard disk?

532


how to select unique records from a table? : Sql dba

629