Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 12 Dec 2012 @ 01:36:00 GMT

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

Subj:   Re: How to copy table containing identity column?
From:   Geeta Kudumula

I am not sure whether you are using Unity or not. But we are on Dual Active System and using Teradata Unity. I heard that we cannot do a insert into table that got identity col. To overcome this limitation, Teradata suggested to drop only the identity col attribute (NOT THE EXACT IDENTITY COL) and keep the column and its data.

Geeta Kudumula
TERADATA Certified Master

  <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: 28 Jun 2020