Members Login:

Forum Statistics:

Forum Members: 24,254
Total Threads: 80,792
Total Posts: 566,472

There are 1377 users currently browsing (tf).

	Our Partners:

TalkFreelance

Design and Development

Programming

.NET and MSSQL :

What is foreign key?

Thread title: What is foreign key?

Thread tools

Search this thread

Display Modes

12-18-2007, 10:37 PM

Luk3

Status: Senior Member
Join date: Nov 2006
Location: Colchester, UK
Expertise:
Software:

Posts: 760

iTrader: 3 / 100%

Luk3 is on a distinguished road

Yeah usually the foreign key is the primary key from another table.

Say you have a customer table and the headers are:
Customer ID [Primary]
Customer Name
ETC

and then you have an Orders table:
Order ID [Primary]
Order item
Customer ID [Foreign]

The tables link via the foreign key. Creates a relationship, Referential Intergrity FTW! ;D