Updating Foreign Keys in Child Tables (ON DELETE CASCADE)

From: Kevin Kinney <kvkinne_at_envc.sandia.gov>
Date: 1995/05/19
Message-ID: <3pina3$9mk_at_news.sandia.gov>#1/1


I am trying to update a primary key in one table which flows down into many other tables, sometimes two or three levels. Is there a command similiar to ON DELETE CASCADE, maybe called ON UPDATE CASCADE, which will let me update the parent table and then cascade those changes to the child tables. Or is there a way to handle this with some SQL. Received on Fri May 19 1995 - 00:00:00 CEST

Original text of this message