Re: Can a foreign key in a table reference another foreign key?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 25 Mar 2002 07:49:07 +0100
Message-ID: <31it9uoqv9s4riiheblh1sltundvuid0j3@4ax.com>

On 24 Mar 2002 18:15:17 -0800, homepalm_at_hotmail.com (Venu) wrote:

>hi,
>
>am a little new to database concepts - here's my doubt:
>
>Can a foreign key in a table reference a foreign key in another table
>which is
>referring a primary key in the third table?
>
>T1 (foreign key of )-->T2(foriegn key of) ---->T1 (prim key)
>
>Please help! this is so confusing :) would grealty appreciate if you
>replied directly to homepalmnospam_at_hotmail.com (remove the nospam)
>
>thank you!

A FK can refer to a PK or an unique key, there are no other options, as this is the definition according to database theory.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Mar 25 2002 - 00:49:07 CST