Updating Primary Key Records and Related FK dependencies
729133Oct 20 2009 — edited Oct 21 20091) How can I found out the name of all the tables that are using my primary key as foreign keys? The primary key is a varchar & used in many other tables. Now the PK records must be changed per client request, so it will obviously affect all my dependent tables.
2) What is the most efficient PL/SQL script to perform this procedure?
Any suggestions will be helpful.
For testing I think I'd like a list of all the tables followed by a list of all the records affected. This report should display the PK record & all dependency records requiring an update. Is this reasonable?