17.10 - Recompiling Stored Procedures - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Fundamentals

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

The ALTER PROCEDURE statement enables recompilation of stored procedures without having to execute SHOW PROCEDURE and REPLACE PROCEDURE statements.

This statement provides the following benefits:
  • Stored procedures created in earlier database releases can be recompiled to derive the benefits of new features and performance improvements.
  • Recompilation is also useful for cross-platform archive and restoration of stored procedures.
  • ALTER PROCEDURE allows changes in the following compile-time attributes of a stored procedure: SPL option or Warnings option.