Guido,

Why not drop the FK, and re-add it later after do what you want?
Generally, it's not a good idea alter directly the system tables.

Luiz.

----- Original Message -----
From: <guido.klapperich@...>
To: <ibobjects@egroups.com>
Sent: Tuesday, December 19, 2000 4:43 PM
Subject: [IBO] OT: No Action -> Cascade


> 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:
> update RDB$REF_CONSTRAINTS set RDB$DELETE_RULE='CASCADE'
> Exists there a solution for my problem ?
>
>
> Guido.
>
>
>
>
>