Cascading delete

387 views
Skip to first unread message

Thotheolh

unread,
May 14, 2012, 11:44:07 PM5/14/12
to h2-da...@googlegroups.com
Is there a feature in H2 that would allow cascading deletes of foreign key linked tables ?

Noel Grandin

unread,
May 15, 2012, 12:03:44 PM5/15/12
to h2-da...@googlegroups.com
Triggers.

On Tue, May 15, 2012 at 5:44 AM, Thotheolh <twzg...@gmail.com> wrote:
> Is there a feature in H2 that would allow cascading deletes of foreign key
> linked tables ?
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/h2-database/-/7byJhUUntfsJ.
> To post to this group, send email to h2-da...@googlegroups.com.
> To unsubscribe from this group, send email to
> h2-database...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.

Thomas Mueller

unread,
May 15, 2012, 1:45:25 PM5/15/12
to h2-da...@googlegroups.com
Hi,

Referential constraints support cascading deletes using "on delete cascade": http://h2database.com/html/grammar.html#referential_constraint

Regards,
Thomas




On Tuesday, May 15, 2012, Thotheolh wrote:
Is there a feature in H2 that would allow cascading deletes of foreign key linked tables ?

--

Thotheolh

unread,
May 15, 2012, 9:47:01 PM5/15/12
to h2-da...@googlegroups.com
Thanks.
Reply all
Reply to author
Forward
0 new messages