Deleting procedures

Once you create a procedure, it remains in the database until someone explicitly removes it. Only the owner of the procedure or a user with DBA authority can drop the procedure from the database.

To delete a procedure (Sybase Central)

  1. Connect to the database as a DBA user or as the owner of the procedure.

  2. In the left pane, double-click Procedures & Functions.

  3. Select the procedure and choose Edit » Delete.

  4. Click Yes.

To delete a procedure (SQL)

  1. Connect to a database as a user with DBA authority or as the owner of the procedure.

  2. Execute a DROP PROCEDURE statement.

Example

The following statement removes the procedure NewDepartment from the database:

DROP PROCEDURE NewDepartment;
See also