How can I find which compatibility mode an H2 database is in?

Question

I know I can set a compatibility mode via SQL in H2, eg.

SET MODE ORACLE

Is there corresponding SQL to query which mode the database is currently in?

Answer 1

You can do:

For new version of INFORMATION_SCHEMA.SETTINGS for H2 2.0 and above:

SELECT SETTING_VALUE FROM INFORMATION_SCHEMA.SETTINGS WHERE SETTING_NAME = 'MODE';

Legacy version of INFORMATION_SCHEMA for H2 1.4.200 and below:

SELECT VALUE FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME = 'MODE';

Then make a case insensitive comparison to the different modes.