H2 Database Query Tool Features
The H2 database query tool provided by RazorSQL includes
visual tools for working with H2 databases, an H2 database browser,
an SQL editor, H2 import and export tools, a query builder, and an edit table tool. See
below for more information.
See the Screen Shot for a visual look:
|H2 Visual and GUI Tools
Includes tools for creating H2 tables and views and tools for altering and dropping tables and views.
|H2 Database Browser
Browse H2 database objects such as tables, views, system tables, columns, primary and foreign keys,
|H2 SQL Editor
Edit SQL scripts. Run SQL queries. Auto column and auto table lookup.
Supports over 20 programming languages including SQL, Java, HTML, XML, and more.
|H2 Import Tool
Import data into H2 from various formats such as delimited files, Excel spreadsheets,
and fixed width files.
|H2 Export Tool
Export H2 data in various formats such as delimited files, Excel spreadsheets, text,
HTML, XML, and SQL insert statements.
|H2 Table Editor
Edit H2 tables in a spreadsheet format with support for finding and replacing data, automatic generation of SQL, and support for editing multi-line data.
|H2 SQL Query Builder
Easily build select, insert, delete, and update SQL queries. Build multi-table joins.
Convert database tables from H2 to other database types such as Oracle, MySQL, MS SQL Server / SQL Azure, PostgreSQL / Redshift, SQLite, Access, and HSQLDB and from other database types to H2.
Below is a screenshot of the RazorSQL H2 database client: