DROP FUNCTION

Transact-SQL Reference

Transact-SQL Reference

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.

See Also

ALTER FUNCTION

CREATE FUNCTION

User-defined Functions