Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 15 May 2013 @ 10:12:23 GMT


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


Subj:   Re: Issues with generated Identity columns
 
From:   A, Surya Kumar

Hi,

When you define columns identity,firstly the number's are not guaranteed to be in sequential order.

in your case :

     INSERT INTO EMPLOYEE5 SELECT * FROM EMPLOYEE4;(employeeid has 1,2,3)

but while inserting into new table it will take system generated values (at random).

While inserting number into the column defined as identity,system will look for (Min and MAX value as per definition and values can be repeated).


Thanks,

Surya



     
  <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: 23 Jun 2019