H2 GUI Tools

RazorSQL provides H2 visual and GUI tools for easily querying, browsing, editing, and managing H2 databases. See below for more information.

  • A create table tool that generates H2 specific create table SQL that includes such elements as column names, column types, column lengths or precisions, column scales, nullability, unique constraints, and default values.
  • A create view tool that generates the SQL for creating H2 views
  • Tools for generating H2 indexes and sequences.
  • A create schema tool that generates the DDL for creating H2 schemas
  • An alter table tool for generating the SQL to alter H2 tables with such options as add column, add primary key, add foreign key, and more.
  • SQL Drop Tools for dropping tables and views.
  • A visual edit table tool for visually editing H2 tables in a spreadsheet format
  • Import and Export tools for importing data into tables, or exporting data from single tables or all tables in a database
  • A Generate DDL Tool for H2 for generating H2 table, view, and index DDL.

For more information about H2 features provided by RazorSQL, see the H2 Features page.