17.00 - Example: Specifying the Same Column in Different Ways - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

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