SQL UDF Usage | CREATE/REPLACE FUNCTION | Teradata Vantage - Function Identifiers - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-12-13
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jbg1472252759029
lifecycle
latest
Product Category
Teradata Vantage™

SQL UDF function names (see Function Name) are distinct from SQL UDF specific function names.

The following table briefly outlines the differences among the different function identifiers:

Function Identifier Syntax Variable Name Definition
Function name function_name The identifier used to call the function from an SQL request.
  • If a specific name is assigned to the function, function_name is not the name by which the dictionary knows the function as a database object, and it need not be unique within its containing database or user.
  • If no specific name is assigned to the function, the function name is the data dictionary is function_name.
Specific function name specific_function_name The identifier used to define the function as a database object in the dictionary table DBC.TVM.