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

How to use boolean type in select statement?

749


What are procedures used for?

698


What is sap sql anywhere?

678


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

739


Why is nosql good?

775






Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

842


How to get list of all tables from a database?

842


Does sql*plus also have a pl/sql engine?

759


Explain the difference between drop and truncate commands in sql?

736


What is pls integer?

777


What does cursor do in sql?

712


Are sql connections encrypted?

747


What is memory optimized table?

761


What is the use of stored procedures?

704


How delete all data from all tables in sql?

685