Archives of the TeradataForum

Message Posted: Tue, 05 Mar 2002 @ 11:34:50 GMT

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

Hi Murthy,

The purpose of ALTER table is to, Add one or more new columns to an existing table.

So, your statement 'alter table t1 add a int;' SHOULD GIVE AN ERROR.

Hope, this answers your query.

Thanks,

Shirish Mallavolu
Saama Technologies Inc.

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