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
Image Image Schemas
 Create Schema Schemas
Image Image Schema
 Export Schema[1], Drop Schema, Rename Schema References, Tables
Image Image Tables
 Create Table[1], Import Table Data[1] References, Tables
Image Image 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
Image Image Columns
   Columns
Image Image Column
   Column
Image Image Indexes
   Indexes
Image Image Index
 Drop Index DDL[1], Index
Image Image Triggers
   Triggers
Image Image Trigger
 Export Trigger[1], Drop Trigger Trigger Editor[1], Info
Image Image Linked Tables
 Create Linked Table Tables
Image Image Linked Table
 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
Image Image Columns
   Columns
Image Image Column
   Column
Image Image Views
   Views
Image Image View
 Export View[1], Script: Script View, Drop View Data, DDL[1], Info, Row Count
Image Image Columns
   Columns
Image Image Column
   Column
Image Image Indexes
   Indexes
Image Image Index
 Drop Index DDL[1], Index
Image Image Triggers
   Triggers
Image Image Trigger
 Export Trigger[1], Drop Trigger Trigger Editor[1], Info
Image Image Sequences
 Create Sequence Sequences
Image Image Sequence
 Drop Sequence Info
Image Image Functions
 Create Function Functions
Image Image Function[2]
 Export Function[1], Drop Function Function Editor[1], Info
Image Image Function
 Export Function[1], Drop Function Function Editor[1], Info
[1] DbVisualizer Pro
[2] Version 2 and later