15.10 - SPECIFIC specific_function_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

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.