15.10 - Example: Modifying Partition Ranges - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
SQL_DDL_15_10.ditamap
dita:ditavalPath
ft:empty

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