15.10 - Example: Modifying Partition Ranges - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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