Re: alter table constraint fails

The sql is successful and I don't get the error if I use:

ALTER TABLE LI_ESTIMATES
 ADD CONSTRAINT XFK_EST_COST_ID FOREIGN KEY (EST_COST_ID)   REFERENCES LI_COST_CAT(EST_COST_ID)
  ON DELETE CASCADE Michael Hill wrote:

> Is it the same as
>
> ALTER TABLE LI_ESTIMATES
> ADD CONSTRAINT XFK_EST_COST_ID FOREIGN KEY (EST_COST_ID)
> REFERENCES LI_COST_CAT(EST_COST_ID)
> ON DELETE NO ACTION
>
> ?
>
> Mike
>
> Michael Hill wrote:
>
> > I am getting a ORA-00905 missing keyword
> >
> > when I attempt to execute this sql
> >
> > ALTER TABLE LI_ESTIMATES
> > ADD CONSTRAINT XFK_EST_COST_ID FOREIGN KEY (EST_COST_ID)
> > REFERENCES LI_COST_CAT(EST_COST_ID)
> > ON DELETE RESTRICT
> > ON UPDATE RESTRICT
> >
> > Anyone see anything wrong with this?
> >
> > Mike
Received on Fri Sep 05 2003 - 16:09:22 CDT