Обсуждение: Update cascade on stmt, not on table definition

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
definedthe 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
likethat? Or do I need to redefine my tables, or the constraints? 

Tks
Felipe Nascimento

Felipe Nascimento
webmaster@peladeiro.com.br
www.peladeiro.com.br

On Thu, 2003-02-06 at 07:22, Felipenasc@aol.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
definedthe 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
likethat? 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