| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Cascaded Updates
Does Oracle support Cascaded Updates? (i.e. if I change the primary key
in a referencing table, will oracle go through and changes all
references in the referencing table).
I have tried the following:
CREATE TABLE MAINTABLE(MAINCODE CHAR(5) NOT NULL, COD1 CHAR(5),PRIMARY
KEY(MAINCODE),
FOREIGN KEY(COD1) REFERENCES SUBDETAIL(COD1) ON UPDATE CASCADE);
Thanks, Stan.
Received on Mon Apr 12 1999 - 10:01:18 CDT
 |
 |