You can add as many changes as you need to a change plan.
Before you begin
If the change plan that you want to add changes to is not
active in change plan toolbar in the Object List,
make the change plan active.
About this task
Tip: As you change objects, you can check the Problems view.
This view highlights which other objects you might need to explicitly
change for the object you are changing.
Procedure
- Optional: To create a new object, in the Administration
Explorer or in the Data Source Explorer, right-click the
folder that contains the type of object to create and then click .
Depending on the object that you are creating, you might be prompted
to specify a schema, table, or view in which to create the object.
Set the attributes for the new object in the Properties view.
For more information about the attributes for an object,
see Data object properties.
- Optional: To alter an object, find the object in the Object
List or in the Data Source Explorer.
Right-click the object and then click Alter.
Change the attributes for an altered object in the Properties view.
- Optional: To drop an object, find the object in the Object
List or in the Data Source Explorer.
Right-click the object and then click Drop.
- To manage the privileges for an object, find the object
in the Object List, right-click the object, and
then click Manage Privileges. Change the privileges
in the Properties view
What to do next
When you are finished adding changes to the change plan,
you can generate and review the commands that are required to make
the changes. You can also close the change plan if you want to work
with it more at a later time.