15.00 - Function Identifiers - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Function Identifiers

SQL UDF function names (see “Function Name” on page 308) 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.