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?
Tks
Felipe Nascimento
Felipe Nascimento
[EMAIL PROTECTED]
www.peladeiro.com.br
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
