Removes one or more user-defined functions from the current database.
drop function{ [ owner_name . ] function_name } [ ,...n ]
is the name of the user ID that owns the user-defined function. Must be an existing user ID.
is name of the user-defined function to be removed. Specifying the owner name is optional; the server name and database name cannot be specified.
Drops the bonus function:
drop function bonus
drop function drops scalar SQL user-defined functions from your current database.
Permissions default to the function owner, and are not transferable. Users with the sa and the dbo roles can drop any object by specifying the owner.