Removing changes from the Objects to be Changed list

As you add objects to the Object to be Changed list and use the Properties view to alter object properties, you can use the undo and redo feature to remove or add back the changes that you make. You can undo and redo the changes only in the order in which they were made.

Procedure

To remove the last change that was made, complete the following steps:

  1. Click Edit > Undo from the menu bar. The Undo label describes what action will be undone.
  2. Optional: To add back the change that you removed, click Edit > Redo from the menu bar. The Redo label describes what action will be redone.

Examples

For example, assume that you just added a table space to the Objects to be Changed as a table space to be dropped. Then, you decide that you do not want to drop the table space. Click Edit > Undo. The Undo label is "Undo Drop table_space_name."

As another example, assume that you want to change the DEPARTMENT and EMPLOYEE tables. You add the DEPARTMENT and EMPLOYEE tables to the Objects to be Changed list as tables to be altered. Next, for the EMPLOYEE table, you add a column named MOBILENO and increase the length of the EMPNO column from CHAR(6) to (CHAR(10). Then, you decide that for this change management script you want to change only the DEPARTMENT table and change the EMPLOYEE table later.

To remove the EMPLOYEE table from the Objects to be Changed list, you must click Undo as many times as you made changes because the changes can be removed only in the order in which they are made. You must click Undo to remove the change to the column length, to remove the new column, and finally to remove the EMPLOYEE table from the list.


Feedback