beautypg.com

HP NonStop G-Series User Manual

Page 218

background image

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

15-13

Figure 15-8. Drop Partition Window.

Choose Partition:

To choose a partition, click on the name of the partition you want to drop
in the Partition Name column..

Display Dependencies

Before dropping partitions from a table, you can analyze the impact of the
changes:

To display the programs which depend on the partitions, click
on Dependent Programs. Programs which would be invalidated
by dropping the partitions are displayed.

To display all objects, including programs, which depend on the
table partitions, click on Dependent Objects. All SQL objects
which depend on the table partitions are displayed.

Drop the Partitions

To drop the partitions from the table, click on one of the following:

Execute. Executes the command immediately.