How to create table if not exists with HSQLDB

Question

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.

Answer 1

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.