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