When the definition of a table or index is modified, all the stored procedures and stored functions that use that table or index are invalidated. In such a case, the invalidated stored procedures and stored functions can be re-created, as explained in this section.

ALTER PROCEDURE or ALTER ROUTINE is used to re-create a stored procedure. ALTER ROUTINE is used to re-create a stored function.