h2 database
H2 Tested for version 1.3 - 1.4, 2.x+
Overview JDBC Drivers Features Supported Objects Download

H2

H2 object type support.

The following table shows the database specific support in DbVisualizer for H2 organized per database object type.

  • Object Type - show what object types are listed in the Databases tab
  • Actions - show what actions are available for the object type
  • Viewers - show what viewers are available for the object type
Object TypeActionsViewers
Schemas
 Create Schema Schemas
Schema
 Export Schema[1], Drop Schema, Rename Schema References, Tables
Tables
 Create Table[1], Import Table Data[1] References, Tables
Table
 Alter Table[1], Create Trigger, Export Table[1], Import Table Data[1], Script: Script Table, Create Index, Drop Table, Empty Table, Rename Table Navigator[1], References, Data, Columns, DDL[1], Grants, Indexes, Info, Primary Key, Row Count, Row Id
Columns
   Columns
Column
   Column
Indexes
   Indexes
Index
 Drop Index DDL[1], Index
Triggers
   Triggers
Trigger
 Export Trigger[1], Drop Trigger Trigger Editor[1], Info
LinkedTables
 Create Linked Table Tables
LinkedTable
 Export Table[1], Import Table Data[1], Script: Script Linked Table, Drop Linked Table, Empty Linked Table, Rename Linked Table Data, Columns, Info, Row Count
Columns
   Columns
Column
   Column
Views
   Views
View
 Export View[1], Script: Script View, Drop View Data, DDL[1], Info, Row Count
Columns
   Columns
Column
   Column
Indexes
   Indexes
Index
 Drop Index DDL[1], Index
Triggers
   Triggers
Trigger
 Export Trigger[1], Drop Trigger Trigger Editor[1], Info
Sequences
 Create Sequence Sequences
Sequence
 Drop Sequence Info
Functions
 Create Function Functions
Function[2]
 Export Function[1], Drop Function Function Editor[1], Info
Function
 Export Function[1], Drop Function Function Editor[1], Info
[1] DbVisualizer Pro
[2] Version 2 and later