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 vote184 views1 answer
Day of the week sqlite
SQL
-2 votes160 views1 answer
Remove root password mysql
SQL
0 vote148 views1 answer
Postgres call view
SQL
0 vote144 views1 answer
Select value from previous row in postgresql
SQL
0 vote151 views1 answer
Sql count null as 0
SQL
1 vote156 views1 answer
Oracle list constraints
SQL
1 vote145 views1 answer
Can we drop a primary key
SQL
2 votes164 views2 answers
Spring where to put the data sql
SQL
0 vote166 views1 answer
Oracle change password expiration policy
SQL
5 votes160 views2 answers
Oracle find all tables with column name
SQL