I believe you want to look at this: http://db.apache.org/derby/manuals/reference/sqlj32.html
Specifically the referential ON UPDATE in constraints. The only "ON UPDATE" actions that are allowed are "NO ACTION" and "RESTRICT"; Derby does not appear to support cascading updates. You can log a feature request, I believe there might already be one for it based on this thread: http://old.nabble.com/ON-UPDATE-CASCADE-in-derby-td1633870.html Incidentally I do believe that MySQL supports on update cascade with its INNODB engine, and I do think MS SQL does as well (http://msdn.microsoft.com/en-us/library/aa275462(SQL.80).aspx) On Mar 15, 2010, at 8:38:12 PM, Rick Genter wrote: > I'm not aware of any database that does this. I know that MS SQL Server does > not. > > > On 3/15/10 3:35 PM, "Gabriele Kahlout" <[email protected]> wrote: > >> I was pretty convinced, that in an update if the referenced column is >> updated so is the refererring. How can one achieve this behavior >> automatically? > > -- > Rick Genter > Principal Software Engineer > Silverlink Communications >
