<div>
The following resets the ID in SQL. Not positive about SQLLite. You could do<br />
<br />

<pre><code id="code-20-35199795-1">DELETE FROM tablename
DBCC CHECKIDENT('tablename', RESEED,0)</code></pre>
</div>


The following resets the ID in SQL. Not positive about SQLLite. You could do



DELETE FROM tablename
DBCC CHECKIDENT('tablename', RESEED,0)

<div>
i fiound solution on my own
</div>


<div>
<div class="content wysiwyg-content">
how can I truncate a table in sqlite? I tried DELETE FROM table; but it doesnt reset the auto incremental ID. any idea?
</div>
</div>


how can I truncate a table in sqlite? I tried DELETE FROM table; but it doesnt reset the auto incremental ID. any idea?

truncate in sqlite

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.