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 vote146 views2 answers
Oracle create chain rule
SQL
0 vote186 views1 answer
Start stop mysql linux
SQL
2 votes196 views1 answer
Remove foreign key constraints in postgres
SQL
13 votes160 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
8 votes164 views1 answer
Oracle search stored procedures for text
SQL
22 votes158 views6 answers
Create sql table
SQL
0 vote219 views1 answer
Mysql readable output
SQL
0 vote149 views1 answer
How to see password mysql vestacp
SQL
7 votes168 views2 answers
How to create index mysql
SQL
0 vote136 views1 answer
Get who is hired in month in sql
SQL