Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 12 Jan 2011 @ 21:16:04 GMT

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

Subj:   Re: Strictly Increasing Identity
From:   frank.c.martinez

While we haven't been using Identity columns for a lot of tables, we do use them in our QA environment, and they've worked fine. The only time we've found problems like you describe occurring is when some loads records INCLUDING the identity column, which have numbers beyond those that have been generated by inserting records WITHOUT the identity column. This can happen when a new copy of the table is created, and records loaded into that copy.


  <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