How to set up H2 Database in the local windows machine

Latest version of  H2 jar can be downloaded from http://repo2.maven.org/maven2/com/h2database/h2/1.4.190/h2-1.4.190.jar

Place the jar in some folder say c:\lib 

H2 database can be started as mentioned below

Go to the folder where the h2*.jar is present say and type cmd from Eplorer.

It will open up a command prompt 

Then type the command as like below

 C:\lib>java -cp h2-1.4.190.jar org.h2.tools.Server

Then a screen will be opened up in the webbrowser.

Some default values will be present in the username, schema ... 

Provide password as sa and then submit

A screen will be shown with tables and schema on the left pane and on the right pane you can type in the sql queries.