Negative indexes

Question

Why do indexes in the database start at -1?

Answer 1

Mary_d9
What index did you mean?

Answer 2

Ipang id in a table

Answer 3

Mary_d9
You mean identity column a.k.a auto increment column? I'm afraid I'm still not getting what you mean here ...

Answer 4

Ipang yes, i'm about it

Answer 5

Mary_d9
As per my understanding, an identity column be adjustable in terms of initial value and incremental step. But I don't see how it makes sense when an identity column should be setup to be initialized by -1 ...
Or maybe some things had changed since last time I read about it ...

Answer 6

Ipang I made it start from 1, but for some reason it starts with - 1, then - 2. However, I save the table and it becomes 1, 2. Its strange.

Answer 7

Mary_d9
Yes, that is strange, in fact, this is first time I hear about such case. I'll try search for it, it's really strange behaviour ...

Answer 8

Mary_d9
Until now I still can't find any similar cases. I look forward for others opinions ...