Re: how do I remove "on delete cascade"?

Brian Lavender <blavender_at_spk.usace.army.mil> schrijfbewerkingen: > I created a table with a "on delete cascade" referencing a foreign key. I
> decided I want to remove that parameter. How do I do that? Here is how I
> created the table.
>
> create table atp_log (
> obli_no varchar2(16) not null,
> delivery_order_no varchar2(4) not null,
> constraint atp_log_fk1 foreign key (obli_no, delivery_order_no) references
> obligation (obli_no, delivery_order_no) on delete cascade
> ); ^^^^^^ I want to remove this
>

You can't actually remove the parameter. Alter Table doesn't allow you to modify a constraint. What you can do however is drop the entire constraint and recreate it without the 'on delete cascade' option. You might want to make sure the data in the tables which are related to the constraints is not modified in the meantime !!

Regards and a happy new year,

Martin. Received on Wed Dec 30 1998 - 03:36:50 CST