15.00 - 15.10 - DDL Statements with Stored Procedures - Teradata Database

Teradata Database Introduction to Teradata

Product
Teradata Database
Release Number
15.00
15.10
Content Type
User Guide
Publication ID
B035-1091-151K
Language
English (United States)
Last Update
2018-09-25

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.