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

• SQL Anywhere database connections
• DROP PROCEDURE statement