Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Stored procedures, triggers, batches, and user defined functions » Procedures

 

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