On Thu, 2003-02-06 at 07:22, [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
