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 » User-defined functions

 

Dropping a user-defined function (SQL)

User-defined functions remain in the database until they are explicitly removed.

Prerequisites

You must be the owner of the user-defined function or have one of the following system privileges:

  • DROP ANY PROCEDURE
  • DROP ANY OBJECT
 Task
  1. Connect to the database.

  2. Execute a DROP FUNCTION statement similar to the following:

    DROP FUNCTION function-name;

Results

The user-defined function is dropped.

Example

The following statement removes the function FullName from the database:

DROP FUNCTION FullName;

 See also