Deleting routines from a project

You can delete routines from your local Data Definition view. Deleting a stored procedure or user-defined function from a project does not drop it from the DB2 database server. Instead, the routine is simply removed from your project folder in your local database definition.

To delete a routine from your local database definition:

  1. Switch to the Data perspective.

  2. In the Data Definition view, right-click the routine that you want to delete, and click Delete.

The routine is deleted from your local data definition.

 

Related concepts

Overview of DB2 stored procedures tasks

 

Related tasks

Viewing and editing source code and properties for DB2 routines
Dropping routines from a DB2 database
Copying DB2 database definitions to a local project