topic Re: Foreign Key? in Application Development and Automation Discussions

Foreign Key?

Former Member — Thu, 10 Jan 2008 23:14:45 GMT

What is meant by Foreign key?

Re: Foreign Key?

abdul_hakim — Thu, 10 Jan 2008 23:15:12 GMT

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

Re: Foreign Key?

Former Member — Fri, 11 Jan 2008 04:10:27 GMT

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.