|
Application - Visual Editing
Aqua Data Studio provides visual editors for database schema
objects, database storage objects and security objects. By
navigating the schema browser a user may locate any object and, by
right-clicking the mouse, get a popup menu with the
CREATE, ATLER and
DROP commands for the object. By selecting the
desired operation the user may visually CREATE,
ALTER or DROP the object. Once
the object has been designed in the form, the user may click the
"Ok" button at which time the form will generate an SQL
statement(s) which are executed on the database to create the
object and refresh the schema browser to show the new
object.
 |
 |
 |
 |
 |
Connect to Server
|
Click on Tables
|
General
Properties
|
Creating Constraints
|
Storage Properties
|
 |
 |
 |
 |
Dimensions in DB2 UDB
|
Summary
|
Add
Comments
|
Preview SQL
|
Enhanced table sorting and filtering: Added sorting and quick
filter to all tables where applicable.
Enhanced Combo Boxes: Now, all comboboxes (where applicable)
support autocompletion, throughout the application. Some comboboxes
are editable and they allow users to type in any text, and some are
strict and allow users to choose an item only from the list.
|
|
Visual Table Editing - Allows for editing table
information by right clicking a table in the Schema Browser and
selecting ALTER Table or CREATE
Table. Below are the tabs and the information that may be visually
edited
 |
 |
 |
 |
 |
Alter Table
|
Select Columns to Alter
|
Alter Column
Property
|
Alter Permissions
|
Preview SQL
|
- General Tab: The Column information is
sortable, expandable and displays more details about the selected
columns. INSERT and DELETE of
columns is available via right click on the Column Names within the
General tab of CREATE and ALTER
dialogs
- Constraints Tab: Constraint properties details
such as Name, Type, Ref Schema, Ref Table and Check Condition are
modifiable visually. Constraint Definition Table Columns and
Referenced Columns can be visually edited
- Storage Tab: Table Storage Properties have been added with
detailed vendor-supported features. The Description area at the
bottom of the window provides explanations for selected terms.
- Comments Tab: Comments are available to all tables.
- Permissions Tab: Permissions are controlable at a fine grain
level, including by column and command. Full grant options are
available and all Permissions can be set by Grantee Type for Users,
Groups or Roles depending on database vendor and type.
- Grant, Grant with Grant Option, Add Grant, Add Grant with Grant
Option, and Revoke are available for SELECT,
INSERT, UPDATE,
DELETE across all databases
- Depending on vendor supported functionality, there are other
permissions which may be set such as ALTER,
INDEX, References, On Commit Refresh, Query
ReWrite
- The "Columns..." button at the bottom right of the
Permissions tab, allows further permissions changes, including
SELECT, INSERT,
UPDATE, and References for the columns
highlighted in the permissions grid within the Permissions
tab.
|
