Managing table constraints – HP NonStop G-Series User Manual

Page 143

Advertising
background image

Managing Tables

12-18

To display all programs that depend on the table, click on
Dependent Programs.

To display all objects, including programs that depend on the table,
click on Dependent Objects.

Enter the New Name

Use the Rename pane to change the table name, as shown in Figure 12-13.
To rename the table, type the new name in the Rename field.

Figure 12-13. Rename Pane.

Rename the Table

To rename the table, 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 Table Constraints

Using dba/m Database Manager you can

Create, change or drop constraints

Add, change, or delete comment text on constraints

Perform these constraint operations from the Tables Menu.

Adding Constraints

Use the Create Constraint window to add constraints to a table. To display
the Create Constraint window

Advertising