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

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016