How do i create a dbo schema in the h2 sqlserver emulator? <p>I'm getting a </p> <pre><code>JdbcSQLException: Schema "dbo" not found; SQL statement: create table "dbo"."TableName" </code></pre> <p>when running some boilerplate sql against the h2 sqlserver emulator (ie, with config settings:</p> <pre><code>db.default.slickdriver=com.typesafe.slick.driver.ms.SQLServerDriver db.default.driver=net.sourceforge.jtds.jdbc.Driver db.default.url="jdbc:h2:file:~/data/test1;MODE=MSSQLServer" </code></pre> <p>running the following:</p> <pre><code>Database.forDataSource(DB.getDataSource()) withSession { </code></pre> <p>I've tried creating the schema:</p> <pre><code> Database.forDataSource(DB.getDataSource()) withSession { implicit session =&gt; Q.updateNA("CREATE SCHEMA \"dbo\" AUTHORIZATION sa;") } </code></pre> <p>but that doesn't seem to do the trick (or report an error message). Am I missing something?</p> <hr> <p>still unable to create the schema programatically. was able to easily create it via the h2 console, using the exact same query as above.</p> <hr> <pre><code>play.api.UnexpectedException: Unexpected exception[JdbcSQLException: Schema "dbo" not found; SQL statement: create table "dbo"."TestTable" ("TestTableId" CHAR(36)) at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$1$$anonfun$1.apply(ApplicationProvider.scala:148) ~[play_2.10-2.2.3.jar:2.2.3] at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$1$$anonfun$1.apply(ApplicationProvider.scala:112) ~[play_2.10-2.2.3.jar:2.2.3] at scala.Option.map(Option.scala:145) ~[scala-library-2.10.4.jar:na] at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$1.apply(ApplicationProvider.scala:112) ~[play_2.10-2.2.3.jar:2.2.3] at play.core.ReloadableApplication$$anonfun$get$1$$anonfun$apply$1.apply(ApplicationProvider.scala:110) ~[play_2.10-2.2.3.jar:2.2.3] at scala.util.Success.flatMap(Try.scala:200) ~[scala-library-2.10.4.jar:na] Caused by: org.h2.jdbc.JdbcSQLException: Schema "dbo" not found; SQL statement: create table "dbo"."TestTable" ("TestTableId" CHAR(36)) at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) ~[h2-1.3.172.jar:1.3.172] at org.h2.message.DbException.get(DbException.java:169) ~[h2-1.3.172.jar:1.3.172] at org.h2.message.DbException.get(DbException.java:146) ~[h2-1.3.172.jar:1.3.172] at org.h2.command.Parser.getSchema(Parser.java:613) ~[h2-1.3.172.jar:1.3.172] at org.h2.command.Parser.getSchema(Parser.java:620) ~[h2-1.3.172.jar:1.3.172] at org.h2.command.Parser.parseCreateTable(Parser.java:5254) ~[h2-1.3.172.jar:1.3.172] </code></pre>