Dropping routines from a DB2 database
You can use the Database Explorer view to drop routines from the DB2 database server. Dropping a routine from the database does not remove any local source code nor remove the routine from your local data definition. If the source of the routine is still in your database definition, you can build the routine again and register it on the server.
Prerequisite: To drop a routine from the DB2 database, have the proper authority. If you do not own the routine, have SYSADM or SYSCTRL authority, DELETE privilege, or the DROPIN authority on the schema. Your DB2 database administrator can provide you with the proper authority.
To drop a routine from a database:
- Switch to the Data perspective.
- In the Database Explorer view, right-click the routine that you want to drop, and click Drop.
The routine is dropped from the database.
Related concepts
Developing DB2 user-defined functions
Overview of DB2 stored procedures tasks
Related tasks
Viewing and editing source code and properties for DB2 routines
Deleting routines from a project
Copying DB2 database definitions to a local project
Related reference
Authorities for DB2 UDB stored procedures and user-defined functions