To delete a function in the Object Explorer, right-click it and click Delete.

To programmatically delete a function:

• In a query window, type DROP FUNCTION followed by the name of the function and execute the statement
• In the Object Explorer, right-click the name of the function, position the mouse on Script Function As, DROP To, and click New Query Editor Window
• Open a new query window associated with the database that contains the function. Display the Templates Explorer and expand the Function node. Drag the Drop Function node and drop it in the empty query window