Export (0) Print
Expand All
ABS
ALL
AND
ANY
AVG
bit
COS
COT
DAY
EXP
GO
IN
LEN
LOG
MAX
MIN
NOT
OR
PI
SET
SIN
STR
SUM
TAN
USE
VAR
Expand Minimize

DROP FUNCTION

SQL Server 2000

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

Show:
© 2014 Microsoft