Foreign Key?

[Former Member]

What is meant by Foreign key?

[abdul_hakim]

Foreign key is a group of fields of a table that can be a primary keys of another table.

To be precise Foreign key fields depends on the value of primary key fields!!

Cheers,

Hakim

[Former Member]

Hi,

Foreign key is a key which relates two tables.The table containing the foreign key is called the foreign key table.A check aganist the feild in which the foreign key is defined must be done with a check table whose primary key must contain that foreign key field with in it.

So, validation of the data is done for the field in which the foreign key is defined.