 |
 |
Archives of the TeradataForum
Message Posted: Thu, 14 Dec 2006 @ 21:27:39 GMT
| Subj: | | Re: Widen a column length with the ALTER TABLE |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, December 14, 2006 15:32 -->
frank.c.martinez wrote:
| | 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. | |
What would the syntax look like?
| |
