What is Foreign Key?
What is the main difference between primary key and Foreign
Key ?
How Foreign Key can be defined?
Is Foreign key is used to join two or more table?

Answer Posted / amol kharat

Sunil is absolutely right.

foreign key may be null but primary key is not null, foeign
key is the reference to other table.

Foreign key is a primary key of reference table.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

1550


What is 'mysqladmin' in mysql?

519


What does do in mysql?

476


what is constraints?

626


What is mysql default database?

474






What is ntext?

609


What is pragma serially_reusable and why is it used?

472


How to get a list of all tables in a database?

575


How to get the number of rows selected or affected by a sql statement?

505


What is mysql aggregate functions? Explain

525


What is the difference between having and where clause in mysql? Explain

534


How to add a new column to an existing table in mysql?

524


How can I remotely connect to mysql database?

445


Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

987


How do I copy a table in mysql?

482