Home » SQL & PL/SQL » SQL & PL/SQL » modify constraint for on cascade delete
modify constraint for on cascade delete [message #18950] Fri, 22 February 2002 07:46 Go to next message
Shubha
Messages: 8
Registered: June 2001
Junior Member
Hi,

Trying to modify an existing foreign key constraint to add
'on delete cascade' option. Is it possible to
do this with out dropping and recreating the constraint. Please help.
I need some direction as soon as possible.
Thank you.
Re: modify constraint for on cascade delete [message #18951 is a reply to message #18950] Fri, 22 February 2002 09:31 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
it is not possible. you have to drop and recreate constraint with on delete cascade option.
Previous Topic: Selecting rows with NULLand BLANK values
Next Topic: Re: Week to date
Goto Forum:
  


Current Time: Fri Sep 24 03:11:58 CDT 2021