Specifying partition names for a PPI

Database

Specifying partition names for a PPI

Hello ,

I have a n00b question, I wanted to know whether its possible to specify names for the individual partitions that we create in the CREATE TABLE statement.

For example, is something like this possible (?) :

 

CREATE TABLE DATABASENAME.SALES_DETAIL 

(.....)

PRIMARY INDEX SALES_DETAIL ( CUST_ORD_ID )

PARTITION BY RANGE_N

(

BUSINESSDAY_DT BETWEEN

PART_1 2007011 AND 2007527 EACH 1 ,

PART_2 2008011 AND 2008527 EACH 1 ,

PART_3 2009011 AND 2009527 EACH 1 ,

PART_4 2010011 AND 2010527 EACH 1 ,

NO RANGE
)
;

 

Or is there some other syntax to implement the same?  That is, naming the individual partitions ?

Regards,

Karan

Tags (2)
2 REPLIES
Teradata Employee

Re: Specifying partition names for a PPI

I dont think its possible, why would you want to have this?

Enthusiast

Re: Specifying partition names for a PPI

No. this option don't exist.