How to create table with column names that look like HSQLDB keywords?

Question

The following SQL will not accepted by HSQLDB because of the name 'position' is a keyword.

CREATE MEMORY TABLE bb (position bigint)

How to create this table without changing the column name?

Answer 1

I don't know HSQLDB, but some SQLs let you use special quotes to force them to accept reserved identifiers.

I'd suggest trying first single quotes, then backticks. If that doesn't work, someone else will hopefully have posted something that does! :)

Answer 2

From the HSQLDB User Guide:

All keywords, can be used for database objects if they are double quoted.

So your statement should simply read:

CREATE MEMORY TABLE bb ("position" bigint)