If we did not create the foreign key with the cascade option but want to add it now, how do we do it?
Have been searching and cannot find the syntax... Looks like there is no modify constraint (besides changing its status)
Thanks,
Nirasha
Printable View
If we did not create the foreign key with the cascade option but want to add it now, how do we do it?
Have been searching and cannot find the syntax... Looks like there is no modify constraint (besides changing its status)
Thanks,
Nirasha
well if I remmeber right you cannot add attributes to a constraint, most probably you have to drop and recreate the constraint