Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 05 Mar 2002 @ 10:43:01 GMT


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


Subj:   On ALTER TABLE
 
From:   Narayan Murthy K S

Hi all,

I have a very basic question. Suppose i have a table t1 with the following definition:

Create table t1(a int,b int);

Now if i try altering the table by adding the same column "a" with the same definition, what should be the result: should i get an error saying duplication of column (as it does when i create a table with similar columns) OR should it pass without giving any error - if it doesn't give an error what is the cause for the same.

Here is the alter table statement : SHOULD IT /SHOULD IT NOT GIVE AN ERROR

alter table t1 add a int;

Narayan.



     
  <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