Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 14 Dec 2006 @ 22:22:08 GMT


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


Subj:   Re: Widen a column length with the ALTER TABLE
 
From:   Vinay Bagare

Hope this helps ..

     create table test ( sno int, addr varchar(10)) primary index (sno);
     show table test;
     Request Text
     CREATE SET TABLE DBA_DB.test ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT
     (
     sno INTEGER,
     addr VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC)
     PRIMARY INDEX ( sno );


     alter table test add addr varchar(200)

Thanks,

Vinay Bagare



     
  <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: 15 Jun 2023