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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Using Procedures, Triggers, and Batches » Introduction to procedures

Copying procedures in Sybase Central Next Page

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. Connect to the database as a DBA user or as the owner of the procedure.

  2. Open the Procedures & Functions folder.

  3. Right-click the desired procedure and choose Delete from the popup menu.

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.

  3. Example

    The following statement removes the procedure NewDepartment from the database:

    DROP PROCEDURE NewDepartment;

    For more information, see DROP statement.