title: Can you create multiple catalogs in H2?
body: <p>When you connect to an embedded local H2 database like so:</p>
  
  <p><code>jdbc:h2:./target/data/CATALOGA;</code></p>
  
  <p>H2 uses the database name (CATALOGA here) as the CATALOG_NAME. This can be seen by querying the INFORMATION_SCHEMA.CATALOGS table.</p>
  
  <p>Is it possible to have more than one catalog?</p>
  
  <p>You cannot insert into the INFORMATION_SCHEMA and H2 does not allow for <code>CREATE CATALOG</code> statements.</p>
  
  <hr>
  
  <p>Background information is that we have queries that join across catalogs. So something that looks like:</p>
  
  <pre><code>select * from CATALOGA.dbo.example e
      inner join CATALOGB.dbo.example2 e2 on e.fk = e2.fk
  </code></pre>
  
  <p>The queries have catalog/schema in them directly and I need to be able to execute them on H2.</p>