Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 07 Jul 2009 @ 10:15:23 GMT


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


Subj:   Re: Need to increase column length for not null column
 
From:   Singh, Lakhwant

Hi Gautam,

You can do it like this:

     Alter Table temp ADD xyz VARCHAR(100);

But you can do it only if column "xyz" is not an indexed column i.e. this column should not have Primary or secondary index defined on it.


Hope this helps.

Lakhwant Singh
Teradata Certified SQL Specialist



     
  <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