Derby
Derby Tested for version 10.2+
Overview JDBC Drivers Features Supported Objects Download

Derby

Derby object type support.

The following table shows the database specific support in DbVisualizer for Derby 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 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