H2
The following table shows the database specific support in DbVisualizer for H2 organized per database 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 |
Linked Tables | Create Linked Table | Tables |
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 |
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 | ||