Archives of the TeradataForum

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

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

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>>