# Create a H2 Database Schema

Published 2022-12-03

This tutorial explains to you how you can create a H2 database schema.

H2 is an open source database written in Java. H2 database can be embedded in Java applications or run in the client-server mode.

H2 database can be configured to run as in-memory database, which means that data will not persist on the disk, but the access is very fast.

H2 provides transaction support (read committed), 2-phase-commit and table level locking.

H2 supports encrypted database (AES), SHA-256 password encryption, encryption functions and SSL.

If you want to create a H2 database schema, it is a simple task. You can use the H2 database Console, but you have to type and run the command in order to create a schema:

When you run the command into the H2 database Console you see if the command run or not. If the command run without errors, you see also the execution time:

Now you can verify if the new H2 database schema is added in the list: