Re: Update cascade on stmt, not on table definition

On Thu, 2003-02-06 at 07:22, Felipenasc(at)aol(dot)com wrote:
> Hi,
>
> I saw I can define a table that specifies a ON UPDATE CASCADE for a Foreign Key.
>
> I have a lot of tables with FK´s, and a lot of others with others FK's for the firts ones, and so on, and I haven´t defined the ON CASCADE clause on the FK´s tables.
> Now I need to update a primary key on the "mother" table.
>
> Is there a way to execute a stmt like 'update tbl set id_field=NEW_ID where id_field=OLD_ID on CASCADE', or something like that? Or do I need to redefine my tables, or the constraints?
>

There is no way to do this in an sql statement. You might be able to
modify the constraints to update instead of delete, though the syntax to
do this escapes me (perhaps someone else can post it?). Otherwise you'll
have to drop and recreate the fk triggers or recreate the table.

Robert Treat