Archives of the TeradataForum

Message Posted: Thu, 14 Dec 2006 @ 19:48:42 GMT

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

You can easily make a VARCHAR longer by the alter statement, but you also need to alter the FORMAT at the same time. If you do the ALTER TABLE with just the new VARCHAR size, the FORMAT stays the same. So just issue the ALTER TALBLE with both the new size and a FORMAT with the new size.

iv

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