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. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority 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
 See also