17.00 - Example: RANGE_N Partitioning Expression Using the END Bound Function - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

This example creates a table whose primary index is partitioned using a RANGE_N expression and an END bound function.

     CREATE TABLE sales_history (
       product_code       CHARACTER(8),
       quantity_sold      INTEGER,
       transaction_period PERIOD(DATE)
     PRIMARY INDEX (product_code)
     PARTITION BY RANGE_N(END(transaction_period) 
                              BETWEEN DATE '2008-03-31'
                              AND     DATE '2015-12-31'
                              EACH INTERVAL '1' YEAR);