|
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.
|
