Wednesday, June 22, 2016

Resetting Autoincrement in Android SQLite after delete table

Try this:
Use this for truncate sqlite table in android
this command  1st delete all from table but Auto-increment Primary key field is exist that reset  2nd command . Totally  You get truncate table. like =  truncate 'table_name' ;
delete from your_table;    
delete from sqlite_sequence where name='your_table';

No comments:

Post a Comment