Many-to-many with both FK cascading deletes?
From: Karsten Wutzke <kwutzke_at_web.de>
Date: Sat, 19 Jun 2010 13:04:36 -0700 (PDT)
Message-ID: <dc4c1372-c494-4c2d-a5ac-e6969bf36355_at_b35g2000yqi.googlegroups.com>
Hello,
Date: Sat, 19 Jun 2010 13:04:36 -0700 (PDT)
Message-ID: <dc4c1372-c494-4c2d-a5ac-e6969bf36355_at_b35g2000yqi.googlegroups.com>
Hello,
are there any complications in general with a many-to-many "join table" having cascading deletes on both foreign keys to the interconnected tables? After all, this means that the "link entities" get deleted whoever comes first... could this pose a problem?
I cannot think of any concrete examples where this could really do harm, but if there are, please enlighten me.
Karsten Received on Sat Jun 19 2010 - 22:04:36 CEST