What is the difference between the Primary and Foreign key?

Answer Posted / dinesh kumar

Primary key will checks for the Duplicates.
Can hold only one primary key for a single table.

Foreign key will be referred from the Primary/unique Key
constraint. Hold even null values in it.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are literals in sql server?

534


What is the difference between delete and truncate commands?

515


How many triggers can be applied on a table?

515


What does varchar include?

519


What is meaning of <> in sql?

587






What is sql resultset?

531


what is a database lock ? : Sql dba

594


what is auto increment? : Sql dba

573


How does an execution block start and end in pl sql?

500


What is pl/sql table? Why is it used?

561


How much does sqlite cost?

558


What is view explain with example?

519


What are secondary keys?

561


How do you update sql?

523


List the different type of joins?

571