You can delete routines from a data development project. Deleting
a stored procedure or user-defined function from a project does not drop it
from any database servers that you previously deployed it to. Instead, the
routine is simply removed from the project.
To delete a routine from your local database definition:
- Switch to the Data perspective.
- From a data development project in the Data Project Explorer, right-click
the routine that you want to delete, and click Delete. If you are deleting a Java™ stored procedure, you can specify whether
to delete the source code.
The routine is deleted from the project.