Dropping database objects

You can use the Review and Deploy dialog to run a DDL script to drop an object from the database.

Before you begin

You must have the appropriate authority to drop objects in the database. A connection to the database must also exist.

About this task

The steps in this task assume that you are dropping an object that is not in a DB2® for Linux, UNIX, and Windows database.

Procedure

  1. Find the object that you want to drop in the Object List or in the Data Source Explorer.
  2. Right-click the object and then click Drop.

    If other objects are impacted as a result of dropping the object, IBM® Data Studio automatically displays the list of impacted objects in the Drop Object dialog. Use this dialog to select the impacted objects that you want to drop in addition to the original dropped object.

    The Review and Deploy dialog opens and displays the generated change commands.

  3. Review the commands in the Review and Deploy dialog and then specify how to deploy the changes to the database.
    Tip: You can modify and then run generated commands in the SQL and XQuery editor. You can also create a job and schedule when to run the generated commands in the Job Manager.

Results

The generated commands are run on the database, and the database object is dropped. The SQL Results view displays the results, including any errors that occurred.

What to do next

Alter any impacted objects that you did not choose to also have dropped to reflect the appropriate changes for the dropped object.

Feedback