15.10 - UDT_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
SQL_DDL_15_10.ditamap
dita:ditavalPath
ft:empty

UDT_name

The name of the UDT, ARRAY, or VARRAY whose definition is to be altered.

SYSUDTLIB.
The specification of SYSUDTLIB is optional.
COMPILE
Do all of the following:
  • Recompile the code source for the specified type.
  • Generate the object code.
  • Recreate the appropriate .so or .dll file.
  • Distribute the recreated .so or .dll file to all nodes of the system.
Teradata Database replaces the existing type with the recompiled version.
COMPILE ONLY
Do both of the following:
  • Recompile the code source for the specified type.
  • Generate the object code.
If you specify COMPILE ONLY, Teradata Database does not generate or distribute the .so or .dll file.
The system does replace the existing type with the recompiled version.