Delete or Change a Function in SQL Server

Question

Hi friends I want to know how to delete or change a function in SQL Server. Thank you.

Senthilkumar · Answer

Hi Vipendra You can do the changes and deletes as like table. While creating you need to do by CREATE statement. After that if you want to use the query window then you can use the following format. ALTER FUNCTION fn_name AS BEGIN //statement here END If you want to Drop the function then DROP FUNCTION fn_name If you use the object explorer then right click of function will generate the code for CREATE ALTER DROP.

Suthish Nair · Answer

You can ALTER or DROP a function..