Archives of the TeradataForum

Message Posted: Fri, 15 Dec 2006 @ 16:08:39 GMT

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

<-- Anonymously Posted: Friday, December 15, 2006 10:14 -->

Check the SQL Reference - DDL manual for restrictions. In general, you can't ALTER the table in a way that requires validation or conversion of existing data.

So for example you can increase the max length of VARCHAR; you can change from NOT NULL to nullable, etc. But you can NOT increase max length, change the length of fixed CHAR, or from nullable to NOT NULL.

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