HP NonStop G-Series - Manual (Page 133)

Managing Tables 12-8
2. Click on Delete. The column is deleted from the Columns pane.
Note: If you delete a primary-key column, the key-sequence number of
all primary key columns will be changed.
3. Repeat steps 1 and 2 to delete columns from the new table.
4. When you are finished deleting columns, click OK. The Edit Columns
window closes and the column list appears in the Create Table window.
Change Column Sequence
You can change the sequence of columns in the Column Name pane.
1. Click on the name of the column in the Column Name field.
2. Click on Up. The column will move up one row.
3. Repeat steps 1 and 2 to sequence additional columns.
Creating Table Partitions
Click on partition in the Create Table window. The Add Partition
window is displayed. See Add Partition in Managing Table
Partitions for detail.
Creating Table Constraints
If you want add constraints to a table, click on Table menu in Main
window , click on constraint menu, and then click on the Create Constraint
window shown in Figure 12-6 is displayed.