Example: Global Temporary Table With Single-Level Partitioning - Advanced SQL Engine - Teradata Database

This example demonstrates a valid CREATE GLOBAL TEMPORARY TABLE request with single-level partitioning.

     CREATE GLOBAL TEMPORARY TABLE g_orders (        o_orderkey      INTEGER NOT NULL,        o_custkey       INTEGER,        o_orderstatus   CHARACTER(1) CASESPECIFIC,        o_totalprice    DECIMAL(13,2) NOT NULL,        o_orderdate     DATE FORMAT 'yyyy-mm-dd' NOT NULL,        o_orderpriority CHARACTER(21),        o_clerk         CHARACTER(16),        o_shippriority  INTEGER,        o_comment       VARCHAR(79))      PRIMARY INDEX (o_orderkey)      PARTITION BY RANGE_N(o_orderdate BETWEEN DATE '1992-01-01'                                       AND     DATE '1998-12-31'                                       EACH INTERVAL '1' MONTH)      UNIQUE INDEX (o_orderkey);