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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Selecting rows with NULLand BLANK values
Next Topic: Re: Week to date
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Aug 21 20:15:45 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.