Question

In sql, which command(s) is(are) used to recompile a stored function?

Answer 1

The answer is ALTER FUNCTION.

In SQL, the ALTER FUNCTION command is used to recompile a stored function. Although the term ALTER is used in the command, it must be noted that the statement does not make any kind of modification to the definition or declaration of an existing function.

Answer 2

ALTER PROCEDURE is used to recompile a stored procedure in SQL.

Just as CREATE PROCEDURE command is used to create stored procedures, ALTER PROCEDURE is used to alter them. It is advantageous to use it to change a stored procedure because it preserves access permissions. The same encryption and recompile options have to be used as the original CREATE PROCEDURE statement. If they are omitted or changed while executing the ALTER PROCEDURE they will be omitted or changed permanently in the actual procedure definition.