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
- Find the object that you want to drop in the Object
List or in the Data Source Explorer.
- 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.
- 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.