Archives of the TeradataForum

Message Posted: Sat, 24 Jan 2009 @ 20:15:41 GMT

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

Example of adding partitions.

     ALTER TABLE STATS_HISTORY.DBQLogTbl MODIFY PRIMARY INDEX ADD RANGE
     BETWEEN DATE '2009-01-16' AND DATE '2009-01-31' EACH INTERVAL '1' DAY

To drop partitions

     ALTER TABLE STATS_HISTORY.DBQLogTbl MODIFY PRIMARY INDEX drop  RANGE
     BETWEEN DATE '2009-01-16' AND DATE '2009-01-31' EACH INTERVAL '1' DAY

Thanks,

Bob Diehl

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