beautypg.com

Altering a table – HP NonStop G-Series User Manual

Page 136

background image

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

12-11

Figure 12-8. Drop Constraint Window.

To drop a constraint, you choose the constraint, then delete it.

In the Constraint pane click on the name of the constraint you want to
delete. The constraint text is displayed in the Constraint Text pane, click on
Execute.

Save the Table

To save the table you created, 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.

Altering a Table

The alter-table function allows you to