16.10 - Recompiling Stored Procedures - Teradata Database

Teradata Database SQL Fundamentals

Teradata Database
Release Number
Release Date
June 2017
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 releases of Teradata Database 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.