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 Type Actions Viewers
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 ↗