drop function

Removes one or more user-defined functions from the current database.

Syntax

drop function{ [ owner_name . ] function_name } [ ,...n ]

owner_name – is the name of the user ID that owns the user-defined function. Must be an existing user ID.
function_name – 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.

drop function drops scalar SQL user-defined functions from your current database.

The permission checks for drop function differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be the function owner or a user with `drop any function` privilege.
Disabled	With granular permissions disabled, you must be the function owner or a user with sa_role.