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

12 votes365 views4 answers
Import mysql database command line linux
SQL
12 votes360 views6 answers
Between in sql
SQL
0 vote353 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote369 views1 answer
Test sql query
SQL
4 votes369 views6 answers
Second max salary in sql
SQL
0 vote350 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
1 vote378 views1 answer
Mysql strict_trans_tables
SQL
0 vote357 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote356 views5 answers
Linq cheat sheet
SQL
0 vote351 views1 answer
Mysql trim characters
SQL