Sqlite reset autoincrement

delete from your_table;    
delete from sqlite_sequence where name='your_table';

Source: stackoverflow.com

How to reset autoincrement in sqlite java

db.delete("SQLITE_SEQUENCE","NAME = ?",new String[]{TABLE_NAME});
/*
when deleting or adding rows with AUTOINCREMENT used to reset counter 
to biggest primary key in table Author Akhilesh Dhar Dubey
*/

-1

Source: stackoverflow.com

Sqlite reset autoincrement

UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'table_name';

-1

Source: designcise.com

Similar codes

2 votes193 views1 answer
Tcl in sql
SQL
0 vote198 views3 answers
Characters found after end of sql statement
SQL
3 votes148 views4 answers
Psql list tables in schema
SQL
0 vote141 views1 answer
Mysql does collate nopad recognize space
SQL
-2 votes180 views1 answer
Mysql not empty
SQL
0 vote139 views1 answer
Postgresql find missing id
SQL
-1 vote167 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
2 votes149 views1 answer
Oracle index size
SQL
-1 vote145 views2 answers
Postgres autoincrement primary key
SQL
0 vote158 views2 answers
Dumping sql table
SQL