drop function

Description

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

Syntax

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

Parameters

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.

Examples

Example 1

Drops the bonus function:

drop function bonus

Usage

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

Permissions

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.