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"