Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 12 Dec 2012 @ 09:57:54 GMT


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


Subj:   Re: How to copy table containing identity column?
 
From:   Dave Wellman

Hi,

The only other way that I've been able to do this is to change the IDENTITY attribute in the target table.

If the target table has "generated by default" then you can copy the data values across and they won't be changed by the dbms. Yes, this means that your etl code may have to change to ensure that it doesn't supply a value and that may be too much work to do.


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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: 15 Jun 2023