To remove the last change that was made, complete the following steps:
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 . 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.