Re: Foreign reference.

fudongli wrote
>I have a table which has a foreign key. But this foreign >key need to reference the primary keys of two other tables.

For sure you can specify more than one foreign key in each table definition. I'd expect you may use the very same column for every foreign key, but am not sure:

Legal:

    create table my_table1
    ( id number(12)
    ...
, primary key(id)

    );

    create table my_table2
    ( id number(12)
    ...
, primary key(id)

    );

    create table my_test
    ( id number(12)
, reference1 number(12)
, reference2 number(12)

    ...
, primary key(id)
, foreign key(reference1) references my_table1(id)
, foreign key(reference2) references my_table2(id)
    );

so hopefully the following is allowed as well:

    create table my_test
    ( id number(12)
, reference1 number(12)

    ...
, primary key(id)
, foreign key(reference1) references my_table1(id)
, foreign key(reference1) references my_table2(id)
    );

Arjan. Received on Mon Mar 08 1999 - 11:43:44 CST