beautypg.com

Renaming a table – HP NonStop G-Series User Manual

Page 141

background image

Managing Tables

12-16

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

Drop the Table

When you are sure you want to drop a table, click on one of the following:

Execute. Executes the command immediately.

Show. Displays the SQL commands created by dba/m Database
Manager.

Queue. Queues the command to be submitted in a batch later.

Renaming a Table

Use the Rename Table window to change the name of a table. You can
also analyze the impact of changing the table’s name by displaying all
objects that depend on the table.

To display the Rename Tables window, click on Tables in the Main
window, then click on Rename. The Rename Table window is displayed, as
shown in Figure 12-12.