... on update cascade ...
From: DeMi <michal.demyda_at_wp.pl>
Date: Tue, 25 Feb 2003 09:26:35 +0100
Message-ID: <b3f95s$4tq$1_at_atlantis.news.tpi.pl>
Hi!
Date: Tue, 25 Feb 2003 09:26:35 +0100
Message-ID: <b3f95s$4tq$1_at_atlantis.news.tpi.pl>
Hi!
[Quoted] I have a question. I have two connected tables. One of them is master and the other is slave. They are connected using foreign key. Is there any possibility, when I am changing content of one field in master table, to update these fields in slave table which are connected by a foreign key to that fiels in master table. I know that exist a clause "... ON DELETE CASCADE" for deleting master fields, but I couldn't find "... ON UPDATE CASCADE". How to do sucha thing by hand?
Best regards
Michal Demyda
Received on Tue Feb 25 2003 - 09:26:35 CET