Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Once you create a user-defined function, it remains in the database until someone explicitly removes it. Only the owner of the function or a user with DBA authority can drop a function from the database.
The following statement removes the function FullName from the database:
DROP FUNCTION FullName;