HP NonStop G-Series User Manual

Page 145

Advertising
background image

Managing Tables

12-20

Assign a Name

Assign a name for the constraint using the Constraint Name pane. Enter the
constraint name in the Constraint Name field.

Enter the Constraint

Use the Constraint Text pane to enter the constraint.

To enter the constraint, place the cursor in the Constraint Text field. You
can

Enter the text of the new constraint, or

Click on a constraint displayed in the Constraints field. The
constraint text is displayed in the Constraint Text field. Edit the
constraint text as necessary.

Save the Constraint

To save the constraint, click on one of the following:

Execute. Executes the command immediately.

Show. Displays the SQL commands created by dba/m Database
Manager without executing them.

Queue. Queues the command to be submitted in a batch later.

Modifying Constraints

Use the Alter Constraint window to modify constraints. To display the
Alter Constraint window

1. Click on Tables in the Main window.

2. Click on Constraint.

3. Click on Alter. The Alter Constraint window is displayed, as shown in

Figure 12-15.

Advertising