sqlhsqldbsql-deletemulti-table-delete

Delete multitable HSQLDB

Are the multitable DELETE statements supported by HSQLDB?

I've done some searches on Google and in the forum, but can't find a topic that deals with this point.

Solution

  • Not directly as of version 2.2.5.

    But you can write a stored procedure to delete from multiple tables according to some criteria, then call the procedure with the necessary parameters. See the Guide:

    http://hsqldb.org/doc/2.0/guide/sqlroutines-chapt.html