Archives of the TeradataForum

Message Posted: Fri, 27 Jan 2006 @ 22:04:11 GMT

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

<-- Anonymously Posted: Friday, January 27, 2006 17:07 -->

          ALTER TABLE %TableName
                MODIFY PRIMARY INDEX
                PARTITION BY CASE_N(C2T_Expir_Dt = '9999-12-31', NO CASE);

Don't forget %TableOwner if you use that feature too.

ALTER TABLE %TableOwner.%TableName

Good to see folks are using ERwin all the way!

Anonym

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