|Programming in MS SQL Server 2012|
In SQL Server Enterprise Manager Application, locate the (EBusiness) database and expand the node, click the user-defined functions node in the left pane and in the right pane, right-click (EmployeeName) name of the function and then click Delete Function option.
Query Output Screen
sp_help is used to displays user-defined function information.
sp_helptext is used to displays user-defined function source code.
* * * * *