Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 02 Aug 2012 @ 23:02:45 GMT

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

Subj:   Re: Using COPY command to copy tables
From:   Fenwick, Ruth

You don't need to delete the data on the target system.....COPY will actually drop and recreate the table structure for you....so if your table happened to have a different structure on the target (say a missing column), COPY to will replace it with the table structure from the source. It will also bring over any statistics you had on the tables.

What I don't remember is what would happen if you had an extra table in the target database and you did a database level COPY ....that extra table may get dropped, but as I said, I don't remember.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016