You can use the following DDL statements with stored procedures. The list is not exhaustive.
| Statement | Description |
|---|---|
| CREATE PROCEDURE | Directs stored procedure compiler to create procedure from SQL statements in remainder of statement text. |
| ALTER PROCEDURE | Directs stored procedure compiler to recompile stored procedure created in earlier version of Teradata Database without executing SHOW PROCEDURE and REPLACE PROCEDURE statements. |
| DROP PROCEDURE | Drops (deletes) stored procedure. |
| RENAME PROCEDURE | Renames stored procedure. |
| REPLACE PROCEDURE | Directs stored procedure compiler to replace definition of existing stored procedure. If specified stored procedure does not exist, creates new procedure by that name from SQL statements in remainder of source text. |
| HELP PROCEDURE ATTRIBUTES | Shows parameters and parameter attributes or creation time attributes of procedure. |
| HELP 'SPL' | Shows DDL and control statements associated with stored procedures. |
| HELP 'SPL' command_name | Shows help about the specified command. |
| SHOW PROCEDURE | Shows definition (source text) of a procedure. Returned text is in format defined by creator. |