Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Stored procedures, triggers, batches, and user-defined functions » Procedures

 

Dropping a procedure (Sybase Central)

You can use Sybase Central to drop a procedure from your database, for example, when you no longer need it.

Prerequisites

You must be the owner of the procedure or have one of the following system privileges:

  • DROP ANY PROCEDURE
  • DROP ANY OBJECT
 Task

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, double-click Procedures & Functions.

  3. Right-click the procedure and click Delete.

  4. Click Yes.

Results

The procedure is removed from the database.

Next

Dependent database objects must have their definitions modified to remove reference to the dropped procedure.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0