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

7 votes238 views4 answers
Lowest salary in sql
SQL
2 votes219 views1 answer
Oracle list grants on procedure
SQL
1 vote219 views1 answer
Create index concurrently postgres
SQL
0 vote241 views1 answer
Report in database
SQL
0 vote223 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
8 votes236 views2 answers
Mysql get first x characters
SQL
0 vote264 views1 answer
Wordpress make wp user in db
SQL
0 vote233 views1 answer
Sql last time database was accessed
SQL
13 votes205 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote212 views1 answer
Mysql trim characters
SQL