0

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?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
sproketboy
  • 8,967
  • 18
  • 65
  • 95

1 Answers1

1

As documented in the manual H2 follows the SQL standard and uses " for quoted identifiers, e.g. "ORDER"