How to reset the id in a table in SQL Posted May 9, 2020 I have a SQL database that I populate from IoT readings. It took me a lot of trail and many errors before I got to the point all readings are stored correctly for reporting. With about 12 sensors each storing a reading every 30 seconds, I have a huge number of records to delete. After successfully delete them I want to start fresh with record id # id is around 2,000,000. How do I reset id counter? Regards Frits
How to reset the id in a table
in SQL
Posted
I have a SQL database that I populate from IoT readings.
It took me a lot of trail and many errors before I got to the point all readings are stored correctly for reporting.
With about 12 sensors each storing a reading every 30 seconds, I have a huge number of records to delete.
After successfully delete them I want to start fresh with record id #
id is around 2,000,000.
How do I reset id counter?
Regards
Frits