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

5 votes118 views2 answers
Sql number columns
SQL
1 vote110 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
26 votes115 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote134 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote108 views2 answers
Mysql regexp match word
SQL
0 vote124 views1 answer
Psql show db
SQL
0 vote130 views2 answers
Reseed sql identity
SQL
3 votes110 views2 answers
Mysql HAVING
SQL
16 votes123 views4 answers
Ascending order mysql
SQL
0 vote77 views1 answer
Create duplicate table in postgresql
SQL