15.10 - Example: Specifying the Same Column in Different Ways - Teradata Database

This example shows several ways to specify the UDT circle for columns cir1 and cir2.

     CREATE TABLE tab_1 (
       c1    INTEGER, 
       cir_1 circle, 
       cir_2 circle NOT NULL);

This example specifies the UDT ellipse for column y and the UDT circle for column z.

     CREATE TABLE tab_2 (
       x CHARACTER(10), 
       y SYSUDTLIB.ellipse, 
       z SYSUDTLIB.circle FORMAT 'X(15)' );