Renaming STORED PROCEDURE in Teradata

You can rename a stored procedure using the RENAME PROCEDURE statement.

Syntax:
RENAME PROCEDURE old_name TO new_name;


Example:

Assume you want to rename the SP_Employee stored procedure as SP_NewEmp.

The statement looks like this:
RENAME PROCEDURE SP_Employee TO SP_NewEmp;