Docu review done: Wed 31 Jul 2024 02:18:02 PM CEST

h2db

Connect to h2db

$ find / -name "*h2*.jar"                                     # to get the h2 jar file
$ java -cp /path/h2-1.3.176.jar  org.h2.tools.Shell           # run h2 jar file
Welcome to H2 Shell 1.3.176 (2014-04-05)                    # welcome msg
Exit with Ctrl+C                                            # how to exit
[Enter]   jdbc:h2:~/test                                    # default by pressing enter
URL       jdbc:h2:/path/to/file/file.h2.db                  # specify your path
[Enter]   org.h2.Driver                                     # default by pressing enter
Driver                                                      # i pressed enter ;)
[Enter]                                                     # no user if press enter
User                                                        # no user if press enter
[Enter]   Hide                                              # no pwd if press enter
Password                                                    # no pwd if press enter
Password                                                    # no pwd if press enter
Connected                                                   # connected msg
Commands are case insensitive; SQL statements end with ';'  #
help or ?      Display this help                            #
list           Toggle result list mode                      #
maxwidth       Set maximum column width (default is 100)    # Shows help
show           List all tables                              #
describe       Describe a table                             #
quit or exit   Close the connection and exit                #
sql>                                                        # start with queries

h2db-Commands

CommandDescription
show tableshows you all existing tables