Scripting Question

Reset user ID number count in database

05/30/2014 1921 views

During some recent experimentation (http://www.itninja.com/question/sql-to-switch-user-ids-part-2) to deal with duplicate user accounts by swapping user IDs, I created an SQL script that changed the ID number in the USER table to 999999999 as a placeholder (i.e. swapping 1111 and 2222: 1111 -> 999999999, 2222 -> 1111, 999999999 -> 2222). This seems to have reset the count somehow, as my import this morning started with ID number 1000000000. Is there a way to set it back to the previous high (in this case, 8200)?

2 Comments   [ + ] Show comments


  • You may want to have support set up a tether and take a look. They should be able to help.
  • While it is possible with an ALTER TABLE command, I would also suggest contacting support.

Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ