15.10 - SPECIFIC specific_function_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Specific name for the function.

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

Unlike function_name (see “function_name” on page 3 ), 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.