Alter a user-defined routine

You can use the ALTER FUNCTION, ALTER PROCEDURE, and ALTER ROUTINE statements to change the routine modifiers or path name of a previously defined UDR. These statements let you modify characteristics that control how the function executes. You can also add or replace related UDRs that provide alternatives for the optimizer, which can improve performance.