The ALTER FUNCTION (SQL Scalar) statement alters an SQL scalar function at the current server.
Modify the definition for an SQL scalar function to indicate that the function is deterministic.
ALTER FUNCTION MY_UDF1 DETERMINISTIC
For more information, see ALTER FUNCTION (SQL Scalar) in the SQL Reference topic in the Information Center.