Subject Re: [ib-support] No Action -> Cascade
Author Paul Reeves
guido.klapperich@... wrote:
> I have to change temporarly the Delete-Rule of some Foreign
> Key-Constraints from No Action to Cascade. These settings are stored in
> the table RDB$REF_CONSTRAINTS. But when I want to change the settings
> with the following update, I always get an error:
> Exists there a solution for my problem ?

I would have thought the right way to go about this problem would be to drop the
original constraints and then apply new constraints. This task will be a lot
easier if you have named your constraints. Otherwise you will have to search
through the appropriate system table ( I forget which ) for the system generated


Paul Reeves
taking InterBase further