DROP FUNCTION
Removes one or more user-defined functions from the current database. User-defined functions are created using CREATE FUNCTION and modified using ALTER FUNCTION.
Syntax
DROP FUNCTION { [ owner_name . ] function_name } [ ,...n ]
Arguments
function_name
Is the name of the user-defined function or functions to be removed. Specifying the owner name is optional; the server name and database name cannot be specified.
n
Is a placeholder indicating that multiple user-defined functions can be specified.
Permissions
DROP FUNCTION permissions default to the function owner, and are not transferable. However, members of the sysadmin fixed server role and the db_owner and db_ddladmin fixed database roles can drop any object by specifying the owner in DROP FUNCTION.