ALTER TYPE Examples | Teradata Vantage - 17.05 - Example: Using the ALTER TYPE Statement with the COMPILE Option - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

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

     ALTER TYPE address COMPILE;

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

     ALTER TYPE phonenumbers_ary COMPILE;