title: Can I add 'ON DELETE CASCADE' to tables managed by Hibernate?
body: <p>I have some tables managed by Hibernate with various foreign key constraints. Cascade on delete is currently managed by Hibernate alone. For playing around with test data I often create and remove some rows by hand. It would help me a lot if I could add ON DELETE CASCADE to the foreign key constraints but I don't know if Hibernate trips over this because the database removes stuff before Hibernate does.</p>
  
  <hr>
  
  <p>A lot of people seem to concentrate on DDL. My intention is <strong>not</strong> to instruct Hibernate to create DDL with SQL DELETE CASCADES. I just want to know if it does any harm if I specify an ON DELETE CASCADE in the database <strong>in addition</strong> to having JPA's <code>cascade = CascadeType.REMOVE</code> on the reference annotation, e.g., <code>@ManyToOne</code>.</p>