Page History
...
The Constraints tab allows the selection of columns for use in constraint creation (including Primary Key) and checks conditions. 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. For more on constraints, see the Creating Constraints page.
The Storage tab provides details on Tablespace and table storage, its content varies depending on server vendor and version.
...
Below are the steps used to create a table in DB2 10.1. Because other databases may not have dimensions, steps 6 and 7 may not be needed.
|
|
|
|
|
|
| ||||||
| 1. Connect to Server | 2. Right Click on Tables | 3. Set General Properties | 4. Create Constraints | 5. Set Storage Properties | 6. Create Dimensions | 7. Dimension Summary |
|
| |
| 8. Add Comments | 9. Preview SQL |
Once a table has been created, it is possible to use Aqua Data Studio's Visual Editing Tools to alter its properties.
...
Below are the steps to alter a table.
|
 |
|
|
|
 |
| ||||||
| 1. Right Click Alter Table | 2. Select Columns to Alter | 3. Alter Column Properties | 4. Alter Permissions Selected | 5. Alter Permissions Altered | 6. Alter Permissions Column Permissions | 7. Preview SQL |
DROP
A right-click on an existing table in the schema browser allows a table to be dropped.
...