RENAME PROCEDURE Syntax Elements - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

old_procedure_name

Existing name for the procedure.

database_name
Optional name of the containing database for the procedure to be renamed if other than the current database.
You cannot use this statement to change the database qualifier for the procedure.
user_name
Optional name of the containing user for the procedure to be renamed if other than the current user.
You cannot use this statement to change the user qualifier for the procedure.

new_procedure_name

New name for the procedure.

For information about naming database objects, see Object Names.

If the UDF library for your database contains any objects with multibyte characters in their name, you cannot use a single-byte session character set to create a new UDF, method, or Java stored procedure object even if the new object name contains only single-byte characters. If you attempt to do so, Vantage aborts the request and returns an error to the requestor. Instead, use a multibyte session character set.
database_name
Optional name of the containing database for the renamed SQL procedure if other than the current database.
user_name
Optional name of the containing user for the renamed SQL procedure if other than the current user.