How to create a new database in H2

[Raghs]

Hi All,

Is there a provision to execute a SQL statement like 'CREATE DATABASE
<myDB>;" which is there in MySQL? I had been trying to create a new
database in H2 but no luck. When I looked at the syntax, there is no
provision for the same except "CREATE TABLE". There is one another
alternative is, "CREATE SCHEMA". Will that be of some help?

Thanks,
Raghavan alias Saravanan M.

[Thomas Mueller]

Hi,

See http://www.h2database.com/html/faq.html#create_database

Regards,
Thomas

[Raghavan.30May1981_GMail]

Hi Thomas,

 Thanks for the link. Shall look into that.

Cheers,
Raghavan alias Saravanan M.
http://groups.google.com/group/S_H_a_D_E

"Do not break the bridge that you might need to cross someday!!!" - Wisemen.