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.

Try to create them anyways and catch and ignore potential exceptions ... would be one solution. — qqilihq, Feb 16 '14 at 17:10

fredt · Answer 1 · 2014-02-17T15:05:38.263

23

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.

edited Feb 17 '14 at 15:05

answered Feb 16 '14 at 22:35

fredt

Thanks, however HSQLDB doesn't allow this query – Khoi Nguyen Feb 17 '14 at 10:23
@JamesWatkins It works also with indexes in version 2.3.4. See [question 18617638](http://stackoverflow.com/q/18617638/3271406) – lu_ko Feb 13 '17 at 16:07
Works for sequences too, woot :) – rogerdpack Oct 20 '20 at 19:12

1 Answers1