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.
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.
Copyright © 2021 Jogjafile Inc.
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