Previous Topic

Next Topic

DROP FUNCTION

Description

Deletes a User Defined Scaler Function (UDF) on the specified table.

Syntax

DROP FUNCTION function_name

Arguments

function_name

The user defined function to be deleted from the table.

Example

DROP FUNCTION str_cat;

Authorization

The user executing this statement must have any of the following privileges:

  • DBA privilege
  • Ownership of the index

SQL Compliance

ODBC Core SQL grammar

Environment

Embedded SQL, interactive SQL, ODBC and JDBC applications

Related Statements

CREATE FUNCTION