Home Home Screenshots Download Documentation Contact Licensing

Documentation: Aqua Data Studio 4.7     HTML Documentation download, ZIP: ads-docs.zip (Size: 20MB) / ads-docs-no-shots.zip (Size: 368KB)
  Getting Started
  Installation
  JDBC Drivers
  I. Oracle
  II. DB2 UDB
  III. SQL Server
  IV. Sybase ASE
  V. Sybase Anywhere
  VI. Informix
  VII. PostgreSQL
  VIII. MySQL
  Character sets
  Registering Servers
  I. MSDE 2000
  II. SQL Express 2005
  III. PostgreSQL SSL
  Application
  I. Browser & Scripting 
  II. Visual Editing
  III. SQL History
  IV. Shortcut Toolbar
  V. Options
  VI. Settings
  Query Window
  I. Basics
  II. Shortcut Keys
  III. Toolbar
  IV. Server Side Comments
  V. SQL Automation
  VI. Variable Binding
  VII. Results
  VIII. Save Results
  IX. Auto-completion
  X. SQL Formatter
  XI. Permissions
  XII. Parameterized
  Visual Explain Plan
  I. Basics
  II. Explain Plan
  III. Explain Diagram
  IV. Whiteboard
  Procedure Editor
  Tools
  I. Table Data Editor
  II. Script Generator
  III. ER Diagram
  IV. Query Builder
  V. Import Tool
  VI. Export Tool

  Oracle DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Rollback Manager
  IV. Log Manager
  V. Security Manager
  VI. Session Manager
  VII. SGA Manager
  VIII. Server Statistics

The Entity Relationship (ER) Diagram Generator helps users achieve a better understanding of their database schema by displaying the structure in a graphical format. To view an ER Diagram:

  1. Launch the ER Diagram Generator dialog by:
    • Selecting Tools -> ER Diagram Generator from the Menu Bar OR
    • Selecting Tools -> ER Diagram Generator from the right-click pop-up menu on a database object in the Schema Browser
  2. Select a Database and Schema (or All Schemas)
  3. In the left panel, select one or more types of objects to be scripted (Tables, Views or Both).
    Click the green check button to select all and the red X button to deselect all.
  4. All objects matching the selected schema & object types will appear in the right panel. Select one or more objects to be scripted.
    Click the green check button to select all and the red X button to deselect all.
  5. Click Next to generate the diagram
  6. Once the diagram is generated, the ER Diagram Viewer will open and display the new diagram.
  7. To change the layout of the diagram, select an entry from the Layout dropdown list.
    Supported layouts include:
    • Box
    • Circle
    • Hierarchical
    • Tree
    • Radial Tree
    • Moen
    • Fruchterman-Reingold (FR)
    • Annealing
    • Inverted Self Organising Map (ISOM)
  8. The Entity View drop-down list determines the amount of detail displayed for each entity in the diagram. Select Full to view all attributes or Header to view only the entity name.
  9. To save an image of the current diagram, click Save Image As.
  10. To print a hard-copy of the current diagram, click Print.
  11. Click on an entity to display more column & constraint detail in the lower left panel.

Aqua Data Studio - ER Diagram Menu
Aqua Data Studio - ER Diagram General
Aqua Data Studio - ER Diagram Window
Home Screenshots Downloads Documentation Support Licensing Copyright© 2001-2006 AquaFold, Inc. All Rights Reserved