16.20 - Example: Modifying Partition Ranges - 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 request modifies the table created in Table Definitions for Examples. The request is valid if the table is empty.

     ALTER TABLE orders 
     MODIFY 
     PARTITION BY RANGE_N(o_orderdate BETWEEN DATE '1993-01-01'
                                      AND     DATE '2000-12-31' 
                                      EACH INTERVAL '1' MONTH);

The following request modifies the partitioning for the column-partitioned table orders_cp. The request is valid if the table is empty.

     ALTER TABLE orders_cp 
     MODIFY
     PARTITION BY (RANGE_N(o_orderdate BETWEEN DATE '1993-01-01'
                                      AND     DATE '2000-12-31' 
                                      EACH INTERVAL '1' MONTH)
                  COLUMN);