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. |