15.00 - Optional Function Characteristics - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

Optional Function Characteristics

The following set of clauses is optional. You can specify all or none of them, and in any order, but each clause defaults to a particular value if it is not specified.

  • Specific function name (see “Specific Function Name Clause” on page 269)
  • Function class (see “Function Class Clause” on page 269)
  • Parameter style (see “Parameter Style Clause” on page 271)
  • Deterministic characteristics (see “Deterministic Characteristics Clause” on page 272)
  • Null call (see “Null Call Clause” on page 272)
  • External data access (see “External Data Access Clause” on page 274)
  • If you specify any of these clauses, you must specify them sequentially prior to specifying the External Clause (see “EXTERNAL NAME Clause” on page 276), which can be followed by a Parameter Style Clause see “Parameter Style Clause” on page 271).