17.05 - RENAME FUNCTION Syntax Elements (External Form) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)
database_name_1
Containing database for specific_function_name if something other than the current database or user.
For information about naming database objects, see Teradata Vantage™ - SQL Fundamentals, B035-1141.
specific_function_name
Existing specific function name to be changed.
You cannot rename a table operator function, that is, a function with a parameter style of SQLTABLE. For more information, see the information about table operators for C/C++ and Java user-defined functions in Teradata Vantage™ - SQL External Routine Programming , B035-1147 .
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, UDT, method, or Java stored procedure object even if the new object name contains only single-byte characters. Otherwise, Vantage returns an error to the requestor. Instead, use a multibyte session character set.
If you specify specific_function_name, then you must also specify new_specific_function_name, not new_function_name.
new_specific_function_name
New specific function name for the function.
You cannot rename a table operator function. For more information, see the information about table operators for C/C++ and Java user-defined functions in Teradata Vantage™ - SQL External Routine Programming , B035-1147 .
database_name_2
Containing database for function_name if something other than the current database.
function_name
Existing overloaded calling name of the function to be changed.
You cannot rename a table operator function. For more information, see the information about table operators for C/C++ and Java user-defined functions in Teradata Vantage™ - SQL External Routine Programming , B035-1147 .
If the UDF library for your database contains any objects with multibyte characters in the name, you cannot use a single-byte session character set to create a new UDF, UDT, method, or Java stored procedure object even if the new object name contains only single-byte characters. Otherwise, Vantage returns an error to the requestor. Instead, use a multibyte session character set.
If you specify function_name, then you must also specify new_function_name, not new_specific_function_name.
data_type
Data type specifications required to uniquely identify an overloaded function to be renamed.
new_function_name
New function name for the function. For information about naming database objects, see Teradata Vantage™ - SQL Fundamentals, B035-1141.
You cannot rename a table operator function. For more information, see the information about table operators for C/C++ and Java user-defined functions in Teradata Vantage™ - SQL External Routine Programming , B035-1147 .