HSQLDB: create schema if not exists -> unexpected token not

Question

I can't find a way to create schema only if it doesn't exist.

I tried:

CREATE SCHEMA IF NOT EXISTS temp

but get unexpected token :NOT error.

However, dropping schema works ok

DROP SCHEMA IF EXISTS temp

Answer 1

This feature will be supported in the next version, 2.4.0.