Re: foreign key rule error

From: Vitaliy Ogiychuk <vitalio_at_infoplus.kiev.ua>
Date: Tue, 22 Oct 2002 15:09:07 +0200
Message-ID: <ap3f15$4kr$1@news.kiev.sovam.com>

"victorrhee" <member_at_dbforums.com> wrote in message news:1953229.1035211692_at_dbforums.com...
>
> create table WORKLOAD
> (
> ENO char(4) not null,
> PNO char(4) not null,
> LOAD number(2,1) not null,
> primary key (ENO, PNO),
> foreign key (ENO) references EMPLOYEE
> on delete cascade
> on update cascade,
> foreign key (PNO) references PROJECTS
> on delete cascade
> on update cascade
> );
> --
> Posted via http://dbforums.com

Clause REFERENCES needs peferencing field in parent table.

create table WORKLOAD
(

     ENO char(4) not null,
     PNO char(4) not null,
     LOAD number(2,1) not null,
     primary key (ENO, PNO),
     foreign key (ENO) references EMPLOYEE(ENO)
             on delete cascade
             on update cascade,
     foreign key (PNO) references PROJECTS(PNO)
             on delete cascade
             on update cascade

); Received on Tue Oct 22 2002 - 08:09:07 CDT