Stored Procedures | SQL Fundamentals | VantageCloud Lake - Stored Procedures - Teradata VantageCloud Lake

Stored procedures are called Persistent Stored Modules in the ANSI/ISO SQL:2008 standard. Stored procedures are written in SQL and consist of a set of control and condition handling statements that make SQL a computationally complete programming language.

These features provide a server-based procedural interface to the database for application programmers.

Teradata stored procedure facilities are a subset of and conform to the ANSI/ISO SQL:2008 standards for semantics.

• Elements of Stored Procedures
• Creating Stored Procedures
• Modifying Stored Procedures
• Running Stored Procedures
• Output from Stored Procedures
• Recompiling Stored Procedures
• Deleting, Renaming, and Retrieving Stored Procedure Information
• Archiving Procedures