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 vote281 views1 answer
Mod function example
SQL
1 vote294 views2 answers
Sql left characters
SQL
0 vote296 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
11 votes321 views2 answers
Having clause in sql
SQL
0 vote304 views1 answer
Postgresql combine values in one field
SQL
2 votes295 views2 answers
Mysql limit
SQL
0 vote314 views1 answer
Procedure excute monthly oracle
SQL
0 vote313 views1 answer
C# get sql min date
SQL
23 votes308 views2 answers
Query to delete a database in mysql
SQL
2 votes289 views1 answer
Import large .sql files into lampp
SQL