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 vote343 views1 answer
Postgres full text search example
SQL
62 votes483 views8 answers
Mysql add column
SQL
3 votes357 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote335 views6 answers
Unique key in sql
SQL
0 vote391 views1 answer
How do you insert boolean to postgresql
SQL
6 votes386 views3 answers
Rename column ORACLE
SQL
0 vote348 views1 answer
Psql list view rules
SQL
16 votes447 views3 answers
Get count of duplicate records
SQL
41 votes451 views6 answers
Alter table add column in SQL Server
SQL
1 vote366 views1 answer
Trim leading zeros in sql
SQL