Dropping User-Defined Functions

Once you create a user-defined function, it remains in the database until it is explicitly removed. Only the owner of the function or a user with DBA authority can drop a function from the database.

For example, to remove the function fullname from the database, enter:

DROP FUNCTION fullname
Related concepts
User-Defined Function Restrictions
Maintenance of User-Defined Functions
Compiling and Linking Source Code to Build Dynamically Linkable Libraries
SQL Data Types
Related tasks
Creating a User-Defined Function
Calling User-Defined Functions
Setting the Dynamic Library Interface
Granting and Revoking Permissions
Using Microsoft Visual Studio Debugger for User-Defined Functions