16.20 - Example: Specifying the Same Column in Different Ways - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

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