Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 13 Feb 2006 @ 16:34:06 GMT


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


Subj:   Removal of FORMAT clauses
 
From:   Woodrow, Steven C

I'm hoping this question doesn't end up being as stupid as it sounds to me, and I have done what I can to not receive RTFM responses. . . .

But.

How do you remove a FORMAT clause with an ALTER TABLE statement?

I have been able to modify a FORMAT, or add a FORMAT to existing columns with the ADD COLUMN phrase.

But, I have not been able to find a way to eliminate one.

Has anyone had to do this?

The alternative, naturally, is to drop and recreate all tables. Or to drop the column, and re-add it without the format. This starts to become overwhelming in scope.


Thank you.



     
  <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