Re: constraint modification

No, sorry

Hth

--
Sybrand Bakker, Oracle DBA
Doug Cowles <dcowles_at_nospambigfoot.com> wrote in message news:385A706F.6ADF7ED2_at_nospambigfoot.com...
> Is there any way to take an existing foreign key constraint and modify
> it to also
> be on delete cascade or on delete set null without recreating the
> constraint from scratch?
>
> For example -
> create table A( a number);
> alter table A add constraint apk primary key (a);
> create table B( b number);
> alter table B add constraint bfk foreign key (b) references A(a);
>
> SQL>alter table B modify constraint bfk on delete cascasde;
> alter table B modify constraint bfk on delete cascasde
> *
> - > SQL comand not properly ended
>
> alter table B modify b add constraint bzy foreign key(b) references A(a)
> on delete
> cascade;
> -> Such a constraint already exists in the table..
>
> alter table B modify b on delete cascade
> -> invalid datatype
>
> etc.,
>
> any way to do this?
>
> - Dc.
>
Received on Fri Dec 17 1999 - 13:26:55 CST