16.20 - SPECIFIC specific_function_name - 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

Specific name for the function.

For information about naming database objects, see Teradata Vantage™ SQL Fundamentals, B035-1141.

Unlike function_name (see function_name ), the specific name for an SQL function, method, or UDT must be unique within its database to avoid name clashes. This name is stored in DBC.TVM as the name of the UDF database object.

This clause is mandatory for overloaded function_names, but otherwise optional and can only be specified once per SQL function definition.

user_name
database_name
An optional database or user name for the specific function.