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

1 vote218 views1 answer
Table valued functions in sql
SQL
0 vote199 views1 answer
Mysql workbench primary key
SQL
0 vote237 views1 answer
Calculer pourcentage mysql
SQL
0 vote204 views1 answer
Storing RGBA in mysql db
SQL
0 vote201 views1 answer
Mysql select where field is a value
SQL
5 votes221 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
1 vote202 views3 answers
Postgresql crete view
SQL
0 vote211 views1 answer
Allow external access to mysql
SQL
1 vote204 views1 answer
Join to find results not in another table
SQL
0 vote216 views3 answers
Mysql regex replace
SQL