15.10 - Example: Specifying the Same Column in Different Ways - 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

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)' );