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 vote148 views1 answer
Expose db in virtualbox
SQL
2 votes195 views2 answers
Mysql on duplicate key update get value from values
SQL
2 votes201 views1 answer
Sql update from different table
SQL
0 vote205 views1 answer
Python mysql show databases
SQL
1 vote217 views1 answer
What is in condition in sql
SQL
0 vote194 views2 answers
Imageview setimageresource null
SQL
1 vote198 views1 answer
Mysql strict_trans_tables
SQL
0 vote194 views1 answer
Sql developer connect to sql server
SQL
9 votes209 views5 answers
Laravel to sql
SQL
0 vote283 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL