I'm using HSQLDB for persisting a small data, in my query I want to create tables at first time and if they are not exist anymore.
However with HSQLDB I cannot execute the query "CREATE TABLE XYS IF NOT EXISTS" like other dbms like mysql or mssql.
Please give me solution for this case.
HSQLDB supports the syntax like the example below:
CREATE TABLE IF NOT EXISTS xyx (a int, b varchar(10))
The syntax is supported by recent HSQLDB 2.3.X versions.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With