Dropping procedures

 Drop a procedure (Sybase Central)

Only the owner of the procedure or a user with DBA authority can drop the procedure from the database.

  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 click Edit » Delete.

  4. Click Yes.

 Drop a procedure (SQL)

Only the owner of the procedure or a user with DBA authority can drop the procedure from the database.

  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