15.00 - CREATE METHOD - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

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

CREATE METHOD

Method Definitions Are Split Between CREATE METHOD And CREATE TYPE Definitions

Unlike other SQL database objects, the definition for a method is split between CREATE METHOD and its signature as defined in its associated CREATE TYPE statement (see “CREATE TYPE (Distinct Form)” and “CREATE TYPE (Structured Form)” in SQL Data Definition Language).

Although the definition for a method is generally similar to that of a UDF, unlike a UDF definition, the following components of a method are defined only in its signature:

  • SPECIFIC NAME clause
  • LANGUAGE clause
  • PARAMETER STYLE clause
  • [NOT] DETERMINISTIC clause
  • SQL data access (NO SQL) clause
  • Note that the RETURNS clause is defined both in the CREATE METHOD definition and in the CREATE TYPE signature for the method.