DROP FUNCTION

The DROP FUNCTION statement removes an existing user-defined function (UDF) from the database.

---

Note
An error message appears if you attempt to delete a UDF that does not exist.

---

Syntax

DROP FUNCTION { function_name }  

Arguments

function_name 

Name of the user-defined function to be removed.

Examples

The following statement drops UDF fn_MyFunc from the database.

DROP FUNCTION fn_MyFunc 

See Also

CREATE FUNCTION