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

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
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)' );