Derby
The following table shows the database specific support in DbVisualizer for Derby organized per database object type.
| Object Type | Actions | Viewers |
|---|---|---|
Schemas | Create Schema | Schemas |
Schema | Export Schema[1], Drop 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, Check Table[2], Compress Table[2], Create Index, Drop Table, Empty Table, Inplace Compress Table[3], Rename Table | Navigator[1], References, Data, Columns, DDL[1], Indexes, Info, Primary Key, Row Count, Row Id |
Columns | Columns | |
Column | Column | |
Indexes | Indexes | |
Index | Script: Script Index, Drop Index, Rename Index | DDL[1], Index |
Triggers | Triggers | |
Trigger | Export Trigger[1], Drop Trigger | Trigger Editor[1], Info |
Views | Views | |
View | Export View[1], Script: Script View, Drop View | Data, DDL[1], Info, Row Count |
Columns | Columns | |
Column | Column | |
Sequences[4] | Create Sequence | Sequences |
Sequence | Drop Sequence | Info |
Synonyms | Create Synonym | Synonyms |
Synonym | Drop Synonym | Info |
Indexes | Indexes | |
Index | Script: Script Index, Drop Index, Rename Index | DDL[1], Index |
Functions | Create Function | Functions |
Function | Export Function[1], Script: Script Function, Drop Function | Function Editor[1], Info |
Procedures | Create Procedure | Procedures |
Procedure | Export Procedure[1], Script: Script Procedure, Drop Procedure | Procedure Editor[1], Info |
Triggers | Triggers | |
Trigger | Export Trigger[1], Drop Trigger | Trigger Editor[1], Info |
|
[1]
DbVisualizer Pro
[2] Version 10.0 and later [3] Version 10.1 and later [4] Version 10.6 and later | ||