update value in multiple tables.
Posted on 2004-09-28
I have a value in the primary key field of one table in SQL2000. I wanted to modify it to some other value but the problem is this field is a foriegn key to lot many other tables with huge amount of data. What is the easiest way to do this?
If this would have been Oracle, I would have disabled all constraints, modified the values in all tables and re-enabled the constraint.
What is the best way in SQL2000. Also, can i find which all table this key is a foriegn key using any tool?
Thanks in Advance,