How to reset Auto Increment Next Value

I wanted to reset the value of an auto increment field. When I go to the field using through the Studio option I can see the current value of the field. Let’s say 159. I have deleted all data so there are no records with existing values. If I try to set this value to say 100. It does not allow me and says the value must be grater than 159. Is there anyway to overcome this? Thanks

I’m not sure, but maybe it’s checking the database to see if some record already exists with 159, and will only allow a number above that to avoid duplicates in the future.

If this speculation of mine is correct, then you could check the database with phpMyAdmin and change the current ids (carefully if you need to keep all the record’s relationships intact).