15.10 - Example: COMPILE Option, ALTER TYPE Statement - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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;