Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 05 Mar 2002 @ 14:07:40 GMT

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

Subj:   Re: On ALTER TABLE
From:   Geoffrey Rommel

  The attribute being referred 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.  

Well, um, it just isn't. I believe you are taking the word "add" too literally. In ALTER TABLE, "add" can mean "add a new column", but if the column-name already exists, "add" will be interpreted as "alter". This is needlessly confusing, in my opinion, but there it is. Computers do not speak English, so there is no requirement that English-like words in a computer language have any relation to their ordinary English meanings. :-(

#define Unless if
#define Maybe {
#define Syzygy }

Unless (a == b) Maybe printf("They're equal!\n"; Syzygy


  <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