JavaDB/Derby - Database Specific Support

DbVisualizer Logo
DbVisualizer 6.0
July 2007
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 SchemaSchemas
Schema
Drop Schema
Tables
Create TableReferences, Tables
Table
Alter Table, Create Index, Drop Table, Empty Table, Import Table Data, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATEColumns, DDL, Data, Indexes, Info, Navigator, Primary Key, References, Row Count, Row Id
Views
Views
View
Drop View, Script: CREATE VIEW, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATEDDL, Data, Info, Row Count
Synonyms
Create SynonymSynonyms
Synonym
Drop Synonym, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATEInfo
Functions
Functions
Function
Drop FunctionInfo
Procedures
Procedures
Procedure
Drop ProcedureInfo
Triggers
Triggers
Trigger
Drop TriggerInfo




Copyright © 2007 Onseven Software AB. All rights reserved.