Drop Unused
Go Up to Available object actions by DBMS
This action lets you build and submit one or more calls to the outln_pkg.drop_unused subprogram, letting you drop outlines that have not been used since being created.
Platform Availability
To Drop One or More Unused Stored Outlines
- Initiate a Drop Unused action against one or more stored outlines. For more information see Initiating an object operation.
- The Drop Unused dialog opens.
- Use the following table as a guide to understanding and modifying settings in this wizard:
Step | Settings and tasks | |
---|---|---|
Preview |
Displays the DDL that will execute the object action. For more information, see Preview. |
- 3. Click Execute. For information on the scheduling option, see Scheduling.
This action lets you build and submit an ALTER TABLE... DROP UNUSED COLUMNS statement, letting you remove columns currently marked as unused.
Platform Availability
To Drop the Clones of one or more Tables
- Initiate a Drop Unused Columns action against one or more tables. For more information see Initiating an object operation.
- Use the following table as a guide to understanding and modifying settings in the Drop Unused Columns wizard:
Step | Settings and tasks | |
---|---|---|
Action Options |
Displays the tables you selected | |
Dependencies |
Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies. | |
Preview |
Displays the DDL that will execute the object action. For details, see Preview. |
- 3. Click Execute. For information on the scheduling option, see Scheduling.