Greetings.
Is it possible to modify a foreign key constraint and force it to cascade on update? If there is no such SQL command, then is it possible to update some system tables to accomplish this?
The problem is that I have a bunch of tables with FK constraints and I need to update primary key values in a lot of these tables. FK constraints were declared, but without cascading updates. Now, I am trying to modify all of them to cascade updates so that I can change primary keys and have these changes propaged to the referencing values.
What would be the easiest solution for this?
Thanks.
Oleg