drop function

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

Syntax

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

Parameters

Examples

Usage

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

Permissions

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

SettingDescription
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.