bandita rani wrote:When to use "foreign key"? if we are getting the same result by using "Joins" then why should we use foreign key?
Thanks and Regards
Bandita Acharya wrote:When to use "foreign key"? if we are getting the same result by using "Joins" then why should we use foreign key?
Experience keeps a dear School, but Fools will learn in no other.
---
Benjamin Franklin - Postal official and Weather observer
Thomas Hauck wrote:A foreign key consists of a column that references another column in another table. This column that is being referred is most often a primary key of the referenced table.
The purpose of the foreign key is to ensure referential integrity of the data.
More on this topic can be found on the following web page.
Foreign Key
Experience keeps a dear School, but Fools will learn in no other.
---
Benjamin Franklin - Postal official and Weather observer