How to modify an existing table constraint

[bk_raavi]

Hai All,
It's possible to modify an existing table constraint -
----for example, to add "ON DELETE CASCADE" to an existing foreign key
constraint?


With regards
Bala Krishna

[TimHall]

Hi.

The syntax diagram for 9i does not give an option to modify this clause of a ref constraint. Looks like you have to drop and recreate it.

See: http://download-west.oracle.com/docs...2a.htm#2081099

Cheers

Tim...