SQL Server Foreign Keys

Foreign key constraints allow you to create relationships between data elements stored in multiple database tables. In addition to facilitating cross-table database queries (called JOINs), these relationships also ensure that the referential integrity of the database is preserved when information is added, removed or modified.

Read the full story: Foreign Keys in SQL Server