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

0 vote243 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote250 views1 answer
Set column in all row mysql
SQL
0 vote241 views1 answer
Group by sql not ordering issues
SQL
32 votes238 views6 answers
Sql count where
SQL
1 vote225 views1 answer
Stop mysql server mac
SQL
0 vote227 views1 answer
Get server date mysql
SQL
0 vote238 views2 answers
Create fulltext index mysql
SQL
3 votes246 views3 answers
Order by postgres
SQL
0 vote243 views1 answer
Insert output identity
SQL
0 vote255 views1 answer
Time data type in mysql
SQL