Page 1 of 1
Forum

Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!

Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.

Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!


Forums
Software Developmen...
Databases
SQLite - Reset Auto...
 
Share:
Notifications
Clear all

[Solved] SQLite - Reset Autoincrement Fields

 
Databases
Last Post by Hans 12 years ago
1 Posts
1 Users
0 Reactions
3,278 Views
RSS
 Hans
(@hans)
Famed Member Admin
Joined: 12 years ago
Posts: 2859
Topic starter October 4, 2013 10:29 AM  

When flushing tables in SQLite, the auto increment fields can be reset as follows for ALL tables:

delete from sqlite_sequence;

Or as follow for a specific table:

delete from sqlite_sequence where name='your_table';


   
ReplyQuote
Forum Jump:
  Previous Topic
Next Topic  
Share: