Adding database object changes to a change plan

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

  1. 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 Create Object. 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.

  2. 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.
  3. 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.
  4. To manage the privileges for an object, find the object in the Object List 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.


Feedback