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
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗