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

user_512461 0
Viewed 743

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?

h2
1 Answers

You can do:

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

Then make a case insensitive comparison to the different modes.

user_13984180
Related