Archives of the TeradataForum

Message Posted: Mon, 21 Jul 2003 @ 21:23:38 GMT

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

The syntax to alter a column is:
ALTER databasename.tablename
ADD columnname column attributes;

However, you cannot alter the length of a column if it involves adding bytes to the internally stored column length. Instead, create a copy of the table with the new column attributes, insert the data from the old table, and rename the tables. Don't forget to collect statistics on the new copy of the table.

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