db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: deleting rows with dependencies
Date Fri, 14 Sep 2007 20:02:54 GMT
> Is there a way to delete rows while automatically deleting other rows
> dependent on those rows?

There are a number of ways. Here's three:

1) ON DELETE CASCADE

2) Write a trigger for the table which implements the delete logic.

3) Always update the table via a stored procedure, and have that
    stored procedure implement your delete propagation logic.

thanks,

bryan



Mime
View raw message