|
|
|
DROP FUNCTION
Description
Deletes a User Defined Scalar Function (UDF) on the specified table.
Syntax
DROP FUNCTION [IF EXISTS] function_name
Arguments
IF EXISTS
This argument avoids failure by attempting to drop the function only if a function of that name already exists.
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:
SQL Compliance |
ODBC Core SQL grammar |
Environment |
Embedded SQL, interactive SQL, ODBC and JDBC applications |
Related Statements |
CREATE FUNCTION |
