Archives of the TeradataForum

Message Posted: Mon, 10 Dec 2012 @ 16:01:54 GMT

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

Hi,

What is the best way to copy a table containing an identity column?

I'd like to do something like this:

     create table ProdTable_Bkup as
     prodTable
     with data;

But of course, that does not work. Other than using the original DDL to create the new table followed by an INSERT step (which I am doing today), is there a more generic way?

Thanks,

Bob

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