16.20 - SPECIFIC FUNCTION - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

The specific function name of the function is to be renamed.

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 “Table Operators” in “C/C++ User-Defined Functions” and “Java User-Defined Functions” of 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, Teradata Database 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.

database_name
user_name
Containing database or user 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.
new_specific_function_name
New specific function name for the function.
You cannot rename a table operator function. For more information, see “Table Operators” in “C/C++ User-Defined Functions” and “Java User-Defined Functions” of Teradata Vantage™ SQL External Routine Programming , B035-1147 .