Delete or Change a Function in SQL Server

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.