JavaDB/Derby - Database Specific Support

Introduction

In addition to the standard feature set in DbVisualizer this document briefly covers the database specific support in DbVisualizer for the JavaDB/Derby RDBMS.

Database Objects Tree

The following table shows what objects DbVisualizer handles for a Derby database. The first column list the structure and the object types. The actions column lists all actions that are associated with the object types and the last column shows all viewers that appear when selecting an object in the tree.

The screenshots illustrates the visual representation of the objects tree.

Object Type Actions Viewers Schemas Create Schema Schemas Schema Export Schema, Drop Schema   Tables Import Table Data, Create Table References, Tables Table Export Table, Import Table Data, Create Trigger, Alter Table, Create Index, Drop Table, Empty Table, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE References, Navigator1, Columns, DDL, Data, Indexes, Info, Primary Key, Row Count, Row Id Columns   Columns Column   Column Indexes   Indexes Index Drop Index, Rename Index, Script: CREATE INDEX DDL, Index Triggers   Triggers Trigger Export Trigger, Drop Trigger Trigger Editor, Info Views   Views View Export View, Drop View, Script: CREATE VIEW, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE DDL, Data, Info, Row Count Sequences2 Create Sequence Sequences Sequence Drop Sequence Info Synonyms Create Synonym Synonyms Synonym Drop Synonym, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Info Indexes   Indexes Index Drop Index, Rename Index, Script: CREATE INDEX DDL, Index Functions Create Function Functions Function Export Function, Drop Function, Script: CALL Function Editor, Info Procedures Create Procedure Procedures Procedure Export Procedure, Drop Procedure, Script: CALL Procedure Editor, Info Triggers   Triggers Trigger Export Trigger, Drop Trigger Trigger Editor, Info 1) DbVisualizer Personal 2) Version 10.6 and later

---