Archives of the TeradataForum
Message Posted: Wed, 15 May 2013 @ 10:12:23 GMT
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).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|