identity column help

Database
N/A

identity column help

I have identity column in TD table. It starts with 1. Then for 2nd run it starts with 10001. Then on 3rd run it starts with 2. Is Identity column not reliable in TD?

is there any reason.....

2 REPLIES
N/A

Re: identity column help

It is reliable to the design. It will assign unique values but not is sequence.

Read the manual carefully and be aware of side effects on copy of data etc.

you might find some answers in 

http://www.teradataforum.com/teradata/20031230_074846.htm

N/A

Re: identity column help

Hi ulrich,

Thank you very much for the quick response.....:)