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