CREATE TABLE Edit
(
editID numeric(5) PRIMARY KEY ,
CONSTRAINT edit_fk FOREIGN KEY (adminID)
REFERENCES Admin (adminID)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT edit_fk FOREIGN KEY (flgihtID)
REFERENCES Flight (flightID)
ON DELETE CASCADE
ON UPDATE CASCADE
);
CREATE TABLE Reservation
(
reservationID numeric(5) PRIMARY KEY,
CONSTRAINT reservation_fk FOREIGN KEY (flightID)
REFERENCES Flight (flightID)
ON DELETE CASCADE
ON UPDATE CASCADE
);
Asked
Active
Viewed 29 times
0
a_horse_with_no_name
- 497,550
- 91
- 775
- 843
overwhelmed
- 1
- 4
1 Answers
0
There is no such thing as ON UPDATE CASCADE in Oracle. There might be in other RDMBSs, but not Oracle. Take that clause out.
eaolson
- 14,065
- 7
- 40
- 54