Re: alter table constraint fails

From: Michael Hill <hillmw_at_ram.lmtas.lmco.com>
Date: Fri, 05 Sep 2003 16:00:43 -0500
Message-ID: <3F58F97B.2BBA5F95@ram.lmtas.lmco.com>

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:00:43 CDT