How to create table if not exists with HSQLDB

2014-02-17 hsqldb create-table

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.

Answers

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.

Related