Identity columns in Teradata

[daewoo]

Hi all,<br><br>Anyone know how to implement a SQL Server Identity Column( A auto incrementing number) in Teradata?<br><br>Thanks for your time

 

[CapsuleCorpJX]

Its better to just do it software side (lock table, get highest number, insert new record with highest number + 1, unlock table).

I don't know if Teradata has autoincrement.

 

[tdatgod]

Hi,
IDENTITY COLUMN is not the same thing as AUTO INCREMENTING.

There is no ANSI requirement that IDENTITY be Contigous numbers just that they be UNIQUE across the whole table.

So which do you want a UNIQUE IDENTITY COLUMN ( which is implmeneted in v2r6 ) or an AUTO INCREMENT column like....

Insert into table
sel MAX(incr)+1,
value,
value,
value ....
from table;