You can use the following DDL statements with stored procedures. The list is not exhaustive.
| Use This Statement… | To… |
|---|---|
| CREATE PROCEDURE | direct the stored procedure compiler to create a procedure from the SQL statements in the remainder of the statement text. |
| ALTER PROCEDURE | direct the stored procedure compiler to recompile a stored procedure created in an earlier version of Teradata Database without executing SHOW PROCEDURE and REPLACE PROCEDURE statements. |
| DROP PROCEDURE | drop a stored procedure. |
| RENAME PROCEDURE | rename a procedure. |
| REPLACE PROCEDURE | direct the stored procedure compiler to replace the definition of an existing stored procedure. If the specified stored procedure does not exist, create a new procedure by that name from the SQL statements in the remainder of the source text. |
| HELP PROCEDURE … ATTRIBUTES | view all the parameters and parameter attributes of a procedure, or the creation time attributes of a procedure. |
| HELP ‘SPL’ | display a list of all DDL and control statements associated with stored procedures. |
| HELP ‘SPL’ command_name | display help about the command you have named. |
| SHOW PROCEDURE | view the current definition (source text) of a procedure. The text is returned in the same format as defined by the creator. |