fritserasmus

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