How can i reset collection type ID field to "1" after deleting every thing

Questions and Answers
3

this is how i have implemented it, but it’s not working, am i missing something, please help.
async afterDelete(data){

   await strapi.connections.default.raw("delete from sqlite_sequence where name='your_table'")

}