FK - automatic value change when parent changes

From: eh <timo.talja.email_at_gmail.com>
Date: Fri, 26 Feb 2010 00:36:45 -0800 (PST)
Message-ID: <5b872e3d-26fc-4509-b079-31a7da73dde1_at_g28g2000yqh.googlegroups.com>



Hi,
we have a Fk pointing to a parent table/column - and now sadly enough that primary key value will change.
What would be a smart way to implement this change to these child tables ?

Disabling FK's and a lot of update clauses or .... ??

BR,
timo Received on Fri Feb 26 2010 - 02:36:45 CST

Original text of this message