Archives of the TeradataForum

Message Posted: Tue, 06 Nov 2012 @ 17:10:08 GMT

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

     CREATE newtable, fallback as oldtable with data;

should do.

If you want any filtering of data, then you can use the SELECT variant with the CREATE TABLE.

Narayan
Wipro

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