Delete multitable HSQLDB

1.7k Views Asked by At

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.

1

There are 1 best solutions below

4
On BEST ANSWER

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