When does a foreign key not reference a primary key ?

(Gary Myers) Generally your foreign key will point to the primary key in the parent table. However it is actually possible to point a foreign key to any column, or set of columns, where uniqueness is enforced through a constraint.

Read More - Register for Free Membership