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
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
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.