beautypg.com

HP NonStop G-Series User Manual

Page 134

background image

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004

12-9

Figure 12-6. Create Constraint Window.

Add a Constraint

When you add a table constraint, you assign the constraint name, define the
constraint, then save the constraint.

1. Enter the name in the Constraint Name field.

2. Enter the constraint text in the Constraint Text pane. Use one of the

following methods to enter the constraint:

Place the cursor in the Constraint Text field and enter the constraint
text, or

Click on the name of an existing constraint in the Constraints Name
field to display the text in the Constraint Text field. Edit the
constraint text to create a new one.

3. To save the new constraint, click on Execute.

Alter a Constraint

If you want alter a constraint, click on Table menu in Main window, click
on constraint menu, and then click on Alter menu, the Alter Constraint
window shown in Figure 12-7 is displayed.