beautypg.com

HP Integrity NonStop H-Series User Manual

Page 157

background image

dba/m Database Manager V7.1 User's Guide – 540156-001

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.

This manual is related to the following products: