sqlite reset autoincrement

Solutions on MaxInterview for sqlite reset autoincrement by the best coders in the world

showing results for - "sqlite reset autoincrement"
Phyllis
22 Oct 2019
1delete from your_table;    
2delete from sqlite_sequence where name='your_table';
Abigail
02 Aug 2018
1db.delete("SQLITE_SEQUENCE","NAME = ?",new String[]{TABLE_NAME});
2/*
3when deleting or adding rows with AUTOINCREMENT used to reset counter 
4to biggest primary key in table Author Akhilesh Dhar Dubey
5*/
Fifi
02 Apr 2018
1UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'table_name';