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

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;