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,
and procedures.
|
|
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:
