Archives of the TeradataForum

Message Posted: Tue, 05 Mar 2002 @ 13:24:48 GMT

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

Hi,

But a column datatype cannot be modified through an ALTER TABLE statement - in order to do so, we have to first drop the column and then add the column with the new datatype.

Had i tried to set the column datatype to some other datatype then this is what i get :

--------------------------------------------------------------------
 BTEQ -- Enter your DBC/SQL request or BTEQ command:
alter table t1 add a char;

alter table t1 add a char;
 *** Failure 3558 Cannot alter the specified attribute(s) for A.
                Statement# 1, Info =0
 *** Total elapsed time was 1 second.
---------------------------------------------------------------------

The attribute being refered to here is the datatype of the column. So if this check is present, then a check to see that i don't duplicate a column should also be present - so why isn't this check present.

Narayan

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