Ultralite 10.0.1.3579

I have a temporary table which has an autoincrement field. When i insert,
say 100 records, to the table, the autoincrement climbs to 100. Now after i
use the temp table, i need to clear it out and it will be nice if i could
somehow rewind the autoincrement back to start from 1. Is there a way to do
this?

I can drop the table and recreate it to get the autoincrement ids to rewind,
but i am guessing it would be better performance wise to touch a system
table and reset it.

TIA
Priyesh

The "Truncate Table" statement is supposed to do that as a side-effect.

But strictly speaking, UL does not support temporary tables, so
I assume you are creating a permanent one and dropping it as
you need it.


"Priyesh" <priyesh_do_not_reply> wrote

The "Truncate Table" statement is supposed to do that as a side-effect.

But strictly speaking, UL does not support temporary tables, so
I assume you are creating a permanent one and dropping it as
you need it.


"Priyesh" <priyesh_do_not_reply> wrote

The "Truncate Table" statement is supposed to do that as a side-effect.

But strictly speaking, UL does not support temporary tables, so
I assume you are creating a permanent one and dropping it as
you need it.


"Priyesh" <priyesh_do_not_reply> wrote

The "Truncate Table" statement is supposed to do that as a side-effect.

But strictly speaking, UL does not support temporary tables, so
I assume you are creating a permanent one and dropping it as
you need it.


"Priyesh" <priyesh_do_not_reply> wrote

The "Truncate Table" statement is supposed to do that as a side-effect.

But strictly speaking, UL does not support temporary tables, so
I assume you are creating a permanent one and dropping it as
you need it.


"Priyesh" <priyesh_do_not_reply> wrote

The "Truncate Table" statement is supposed to do that as a side-effect.

But strictly speaking, UL does not support temporary tables, so
I assume you are creating a permanent one and dropping it as
you need it.


"Priyesh" <priyesh_do_not_reply> wrote

The "Truncate Table" statement is supposed to do that as a side-effect.

But strictly speaking, UL does not support temporary tables, so
I assume you are creating a permanent one and dropping it as
you need it.


"Priyesh" <priyesh_do_not_reply> wrote

The "Truncate Table" statement is supposed to do that as a side-effect.

But strictly speaking, UL does not support temporary tables, so
I assume you are creating a permanent one and dropping it as
you need it.


"Priyesh" <priyesh_do_not_reply> wrote

The "Truncate Table" statement is supposed to do that as a side-effect.

But strictly speaking, UL does not support temporary tables, so
I assume you are creating a permanent one and dropping it as
you need it.


"Priyesh" <priyesh_do_not_reply> wrote