15.10 - Example: COMPILE Option, ALTER TYPE Statement - 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)
Last Update
2018-06-05

The following example recompiles the UDT named address, generates the appropriate object code, generates the new .so or .dll library, and redistributes it to all system nodes.

     ALTER TYPE address COMPILE;

The following example recompiles the one-dimensional ARRAY named phonenumbers_ary, generates the appropriate object code, generates the new .so or .dll library, and redistributes it to all system nodes.

     ALTER TYPE phonenumbers_ary COMPILE;