How do I...?

Reset an Auto Counter?

Is it possible to completely reset the auto counter for a table?
I have tried deleting a current one & creating a new one, but the numbers don't reset.
I know that I can "reset" it by re-creating the same table, but I'd like to avoid that.

9 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Kimberly Wakefield shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

5 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Kathy commented  ·   ·  Flag as inappropriate

    Surely TV could implement auto-counter resetting by using TRUNCATE TABLE tablename...? Then you'd still have to re-import data but at least the structure would be intact...

  • John McGarvey commented  ·   ·  Flag as inappropriate

    I'm wondering if there is any update on this topic.
    I just came across a need to reset the Auto Counter after import some records, and it appears to have doubled the number of records.
    Would the Auto Counter reset if I deleted all records, deleted the Auto Counter field, recreated the Auto Counter, then reimporting my source file?

  • Jake Marwil commented  ·   ·  Flag as inappropriate

    Hi Adam,

    Although this works in certain instances, we would not recommend setting the autocounter to start at a negative value as this can cause errors in your table. Please let us know if you have any questions.

    Regards,

    Jake

  • Adam Carley commented  ·   ·  Flag as inappropriate

    We also encountered this problem. It turns out that the autocounter will accept a negative starting value. So we set it to "-12" so that our #13 turned into #1

  • Jake Marwil commented  ·   ·  Flag as inappropriate

    Hi Kimberly,

    Hope you are well. Unfortunately, there isn't a way to reset an autocounter other than recreating the table. However, we can understand how this would be a nice feature to have. We will be sure to pass this request along to our product team. Please let us know if you have any further questions or comments.

    Regards,

    Jake

Feedback and Knowledge Base