11.1.2 Creating Constraints (Revision #4)

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.

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.

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