Archives of the TeradataForum
Message Posted: Mon, 10 Dec 2012 @ 16:01:54 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|