Skip to content
Advertisement

What are the the H2 delimiters for Table and Column Names?

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"

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement