Hi,
We have a table that has been partitioned as the dataset will grow into the billions of rows. It has a Primary Index, here is the bottom part of the show table which contains the partition statement:
PRIMARY INDEX (OFFER)
PARTITION BY ( RANGE_N(Week_ID BETWEEN 201201 AND 201253 EACH 1 ,
201301 AND 201353 EACH 1 ,