Drop Clone
Go Up to Available object actions by DBMS
If you have created a clone from a base table, you can drop that clone. To determine whether a table has a clone, see the Dependencies tab/panel on a Table editor or on the wizard for object actions such as Drop or Rename.
Platform Availability
- DB2 z/OS version 9 ^
To Drop the Clones of One or More Tables
- Initiate a Drop Clone 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 Confirm Drop Clone wizard:
Step | Settings and tasks | |
---|---|---|
Action Options |
Lets you review the action you initiated. | |
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. |
- 3. Click Execute. For information on the scheduling option, see Scheduling.
Related Information