I have a legacy DB with column names which have keywords in them – I want to transfer to H2 without having to rename anything.
What can I use with SQL syntax to delimit column and table names?
SQL Server uses []
, MySQL uses ``
, Oracle uses ""
, and what does H2 use?
Advertisement
Answer
As documented in the manual H2 follows the SQL standard and uses "
for quoted identifiers, e.g. "ORDER"