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 is meant by urlencode and urldocode? : Sql dba

590


What is trigger in pl sql with examples?

511


What is pl sql collection?

514


What is structural independence and why is it important?

539


How is data stored in sql?

543






Can we create foreign key without primary key?

525


What is trigger in flip flop?

511


How do I run a pl sql procedure in sql developer?

503


what is sp_pkeys? : Transact sql

688


write an sql query to find names of employee start with 'a'? : Sql dba

571


What is sql lookup?

500


How do I find duplicates in two columns?

543


Why having clause is used in sql?

530


What does data normalization mean?

523


Define overloaded procedure?

616