How to connect to specific Schema in H2

There is such feature supported. See this:

http://www.h2database.com/html/grammar.html#set_schema

You can specify the schema in the connection string:

jdbc:h2:test;SCHEMA=SCHEMA_NAME

You can also change the current schema with:

SET SCHEMA SCHEMA_NAME;

Hope this helps.

SET SCHEMA_SEARCH_PATH shemaName

http://h2database.com/html/grammar.html?highlight=drop%2Calias&search=drop%20alias#set_schema_search_path

Related