how to reset table id ?

xchinjo · 2016-10-30 10:45:52

how to reset table id to 0 or any number?

ab · 2016-10-30 17:54:48

There is no record with Id=0 by design.

xchinjo · 2016-10-30 23:29:10

i'm sorry, i mean reset to 1

ab · 2016-10-31 07:41:31

I don't understand what you mean...
Do you mean change the record ID to another value?

In this case, there is no way of doing it directly from the ORM, but by creating new records with the new ID and copied fields values, then delete the old records.
You may do it using raw SQL, anyway - but ensure you flush the cache.

xchinjo · 2016-10-31 09:52:42

i mean like this post
http://synopse.info/forum/viewtopic.php?id=1664

after delete all data of table the ID already continued value. i want to reset id to start from number 1 when the table is empty
,How to flush the cache?

Last edited by xchinjo (2016-10-31 09:56:05)

ab · 2016-10-31 11:44:17

For a SQlite3 table, it is a SQLite3 feature.
See http://stackoverflow.com/a/3443682/458259

xchinjo · 2016-10-31 13:03:49

Thank you. Ab

jbroussia · 2016-10-31 13:51:18

Doesn't VACUUM do this in SQLite ?

mORMot Open Source

#1 2016-10-30 10:45:52

how to reset table id ?

#2 2016-10-30 17:54:48

Re: how to reset table id ?

#3 2016-10-30 23:29:10

Re: how to reset table id ?

#4 2016-10-31 07:41:31

Re: how to reset table id ?

#5 2016-10-31 09:52:42

Re: how to reset table id ?

#6 2016-10-31 11:44:17

Re: how to reset table id ?

#7 2016-10-31 13:03:49

Re: how to reset table id ?

#8 2016-10-31 13:51:18

Re: how to reset table id ?

Board footer