Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ON DELETE CASCADE
drop the constraint and recreate it. There's no other way, sorry.
Hth,
Sybrand Bakker, Oracle DBA
wolfgang karrer <wolfgang.karrer_at_ce.uni-linz.ac.at> wrote in message
news:38e9d7b0_at_alijku02.edvz.uni-linz.ac.at...
> Hi everyone,
>
>
> how is it possible to change a foreign key constraint to do the on delete
> cascade?
>
> CREATE TABLE Verfahren
> (verfahrenNr INTEGER PRIMARY KEY,
> bezeichnung VARCHAR2(50) NOT NULL,
> beschreibung VARCHAR2(500),
> ziel VARCHAR2(500),
> datumerstellt DATE,
> erhebNr INTEGER NOT NULL,
> CONSTRAINT erhebNr_verfahren FOREIGN KEY (erhebNr) REFERENCES
> ERHEBUNGSMETHODE (erhebNr));
>
> This is the table i created for a few years. Now i want to add a on delete
> cascade to the constraint erhebnr_verfahren. How is this possible?
>
> ALTER TABLE Verfahren modify ...
>
> Thanks a lot
>
>
>
> --
> Wolfgang Karrer
> Büro für EDV-Dienstleistungen
> Gewerbegasse 6
> 4060 Leonding
> Tel + Fax. (0732) 681795
> Mobil: (0699) 134 18 469
> EMail: w.karrer_at_ooenet.at
> ---------------------------------------
> Institut für Wirtschaftsinformatik
> Abteilung Communications Engineering
> o.Univ.- Prof. DI Dr. Christian Stary
> Freistädterstr. 315
> 4040 Linz/Urfahr
> Tel: (0732) 2468-7112
> EMail: wolfgang.karrer_at_ce.uni-linz.ac.at
>
>
>
Received on Tue Apr 04 2000 - 06:55:59 CDT