Re: foreign key?

From: Tim Cuthbertson <timcuth_at_my-deja.com>
Date: Tue, 30 Nov 1999 19:34:48 GMT
Message-ID: <8218so$tk4$1@nnrp1.deja.com>

No. A foreign key must always refer to the primary key of the parent table.

Tim

In article <820qfd$ic5$1_at_nnrp1.deja.com>, ibm_97_at_yahoo.com wrote:
> The PK of table A is (col_a, col_b). In table B, is there a way to
> assign a foreign key which is 'references A(col_a)'?
>
> In Oracle 8.
>
> Thanks! Pls also email me a copy.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 30 1999 - 13:34:48 CST