Owner manual

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005 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.