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 vote315 views2 answers
2nd max salary query in sql
SQL
0 vote373 views1 answer
Postgresql custom order by
SQL
-1 vote307 views1 answer
Mysql coalesce
SQL
0 vote337 views4 answers
Mysql count table rows
SQL
0 vote344 views1 answer
Compare subqueries oracle
SQL
1 vote306 views1 answer
Truncate table in postgresql and reset id
SQL
49 votes409 views6 answers
Mysql add column to table
SQL
0 vote357 views1 answer
Como saber si tengo mysql instalado
SQL
13 votes325 views5 answers
Select last row mysql
SQL
4 votes316 views2 answers
Error loading MySQLdb module.
SQL