![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Tue, 05 Mar 2002 @ 14:07:40 GMT
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
--wgr
| |