You can make additional changes to objects that already
have planned changes. For example, you might want to change the attributes
of a table that is being created or one that is being altered.
Before you begin
If the change plan that you want to modify the object changes
for is not active in the change plan toolbar in the
Object
List,
make the change
plan active.
About this task
Not every changed object in the change plan can be modified.
When you modify a changed object, the product attempts to automatically
adjust any other planned changes that are affected by your modifications.
In some cases, some dependencies cannot be handled automatically,
and you will need to check the
Problems view
to determine the actions that you need to take. You can make the following
types of changes:
- You can edit an existing change for an object. For example, you
dropped a column from a table and now want to add two new columns
to a table.
- You can add a change to drop an object that was created in a change.
For example, you planned to create a table, but the table is no longer
needed.
- You can add a change to drop an object that was altered in a change.
For example, you added a column to a table, but the table is no longer
needed.
Procedure
- In the change plan toolbar, click the linked number in
the
(Show
plan changes) icon. The changes in the
change plan are displayed in the Object List.
- Review the changes.
- To make additional changes to a changed object, complete
the following steps:
- Find the changed object in the Object List.
- Right-click the object and then click Alter.
- Change the attributes for the object in the Properties view.
- To add a change to drop a changed object, complete the
following steps.
- Find the changed object in the Object List.
- Right-click the object and then click Drop.
Results
The change plan is updated to reflect your changes.
What to do next
You can generate and review the commands that are required
to change the database. You can also close the change plan if you
want to work with it at a later time.