Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: On ALTER TABLE
From:   Narayan Murthy K S


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.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019