ALTER FUNCTION

>>-ALTER-------------------------------------------------------->
 
                            .-,------------------.
                            V                    |
>--+-FUNCTION--function--(----+----------------+-+--)-+--------->
   |                          '-parameter_type-'      |
   |                                      (1)         |
   '-SPECIFIC FUNCTION--| Specific Name |-------------'
 
         .-,------------------------------------------------------------------.
         V                                    (2)                             |
>--WITH(---+-+-ADD----+--| Routine Modifier |-------------------------------+-+-)-><
           | +-MODIFY-+                                                     |
           | '-DROP---'                                                     |
           |  (3)                                                      (4)  |
           '--------MODIFY EXTERNAL NAME =--| Shared-Object Filename |------'

Notes:

See Specific Name
See Routine Modifier
External routines only
See Shared-Object Filename

Element	Description	Restrictions	Syntax
function	User-defined function to be modified	Must be registered in the database. If the name does not uniquely identify a function, you must enter one or more appropriate values for parameter_type.	Database Object Name
parameter_type	Data type of a parameter	Must be the same data types (and specified in the same order) as in the definition of function	Identifier

The ALTER FUNCTION statement can modify a user-defined function to tune its performance by modifying characteristics that control how the function executes. You can also add or replace related user-defined routines (UDRs) that provide alternatives for the query optimizer, which can improve performance.

All modifications take effect on the next invocation of the function.

Only the UDR owner or the DBA can use the ALTER FUNCTION statement.

ALTER FUNCTION

Syntax

Usage