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 vote158 views1 answer
Define a variable in mysql from select
SQL
0 vote156 views1 answer
Postgresql import a database of gzip
SQL
0 vote178 views1 answer
Update sql sintax
SQL
1 vote95 views1 answer
Metada in sql
SQL
3 votes144 views1 answer
How to find names includes in sql
SQL
0 vote141 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote162 views1 answer
How to get button for every record from mysql
SQL
0 vote248 views1 answer
How to use select union and loop
SQL
25 votes158 views4 answers
Metadata
SQL
23 votes147 views4 answers
How to show all users in mysql
SQL