Example: Modifying Partition Ranges - Advanced SQL Engine - Teradata Database

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