ASA SQL User's Guide
  Using Procedures, Triggers, and Batches
    Introduction to procedures

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 a database as a user with DBA authority or as the owner of the procedure.

2. Open the Procedures & Functions folder.

3. Right-click the desired procedure and choose Delete from the popup menu.

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 new_dept from the database:

DROP PROCEDURE new_dept

For more information, see DROP statement.