Archives of the TeradataForum

Message Posted: Wed, 03 Nov 2004 @ 13:51:46 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

1.) you can only partition the PI --> No way to add a PI to a table ;)

2.) Once the table has a PPI, you can modify it.

Sample:

     alter table T1 modify primary index add range ......;
     alter table T1 modify primary index delete range .....;

Christian

	<Prev	Next>		<<First	<Prev	Next>	Last>>