New answers tagged auto-increment
If you only need to eliminate the last rows which have not followed the incremental value of an identity field, there is an easy and safe way: first delete the last record(s) which have 'jumped' change the data type of your Identity Field (from int to bigint or vice versa) save the table add a new record, and check it assigns the number of the highest ...
Assuming you're using a 64 bit system, an INT(eger), 2^64 = 18,446,744,073,709,551,616, so if you have an insert every nanosecond, your system will run out of numbers after approximately 600 years - I wouldn't worry too much! :-)
Top 50 recent answers are included