HP NonStop G-Series - Manual (Page 148)

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005 12-23
Choose a Table
Use the Catalogs and Tables pane to choose a table.
To choose the table
1. In the Catalogs field, click on the name of the catalog that contains the
table. The tables in the selected catalog are displayed in the Tables
field.
2. In the Tables field, click on the name of the table. The constraints for
the table are displayed.
Choose a Constraint
Use the Constraint Name pane to choose a constraint to drop. Click on the
constraint in the Constraint Name field. The constraint text is displayed in
the Constraint Text pane.
Drop the Constraint
To drop 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.
Managing Constraint Comments
Using the Comments for Table Constraints window, you can add, change,
or delete constraint comments. Constraint comments consist of one or
more lines of text. To display the Comment on Constraint window
1. Click on Tables in the Main window.
2. Click on Constraint.
3. Click on Comment.
The Comments for Table Constraints window is displayed, as shown in
Figure 12-17.