Re: FK - automatic value change when parent changes
Date: Fri, 26 Feb 2010 17:13:41 +0000 (UTC)
On Fri, 26 Feb 2010 00:36:45 -0800, eh wrote:
> 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 .... ??
Redesigning the application would be the best choice, if you ask me. Public execution of the original designer which includes quartering should also be considered.Received on Fri Feb 26 2010 - 11:13:41 CST