Dropping routines from a database

You can use the Database Explorer to drop routines from a database server. Dropping a routine from the database does not remove any local source code nor remove the routine from any data development projects that contain it. If the source of the routine is still in a data development project, you can deploy the routine again and register it on the server.

Prerequisite: To drop a routine from a DB2® database, you must have the proper authority. If you do not own the routine, you must 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:

  1. Switch to the Data perspective.
  2. In the Database Explorer, right-click the routine that you want to drop, and click Drop.
The routine is dropped from the database.

Comentarios