Archives of the TeradataForum

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

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

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>>