JavaDB/Derby - Database Specific Support

DbVis Software
DbVisualizer 8.0 http://www.dbvis.com
support@dbvis.com


Master documentation index

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


Copyright © 2011 DbVis Software AB. All rights reserved.