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 ,