H2
H2 object type support.
The following table shows the database specific support in DbVisualizer for H2 organized per database object type.
H2
The following table shows the database specific support in DbVisualizer for H2 organized per database object type.
Object Type | Actions | Viewers | |||
---|---|---|---|---|---|
|
Create Schema | Schemas | |||
|
Export Schema[1], Drop Schema, Rename Schema | References, Tables | |||
|
Create Table[1], Import Table Data[1] | References, Tables | |||
|
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 | ||||
|
Column | ||||
|
Indexes | ||||
|
Drop Index | DDL[1], Index | |||
|
Triggers | ||||
|
Export Trigger[1], Drop Trigger | Trigger Editor[1], Info | |||
|
Create Linked Table | Tables | |||
|
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 | ||||
|
Column | ||||
|
Views | ||||
|
Export View[1], Script: Script View, Drop View | Data, DDL[1], Info, Row Count | |||
|
Columns | ||||
|
Column | ||||
|
Indexes | ||||
|
Drop Index | DDL[1], Index | |||
|
Triggers | ||||
|
Export Trigger[1], Drop Trigger | Trigger Editor[1], Info | |||
|
Create Sequence | Sequences | |||
|
Drop Sequence | Info | |||
|
Create Function | Functions | |||
|
Export Function[1], Drop Function | Function Editor[1], Info | |||
|
Export Function[1], Drop Function | Function Editor[1], Info | |||
[1]
DbVisualizer Pro
[2] Version 2 and later |