first download Hsqldb2.2.4 zip and extract click to terminal/cmd and type cd hsqldb
cd lib
java -cp hsqldb.jar org.hsqldb.util.DatabaseManagerSwing then it opens the HSQL Database Manager give the settingname and username and password and then click ok
it opens the window and you can create table,insert,update and delete in command mode