I have a table with a AutoInc field. Every morning I insert 55000 records
and at the end of the day I delete all of them (delete from table1). I am
afraid, that AutoInc will rise to high. Is there a way, I can reset that
AutoInc?
please advise,
Andrej

Andrej,

The maximum value for Autoinc is 2147483647, so if you started at 0 and
you are going to add 55000 record a day, you may add records for
2147483647 DIV 55000 = 39045 days (about 106 years)  
Even so, if you want to reset the Autoinc, you may use the following SQL:

ALTER TABLE <YourTableName>
REDEFINE <YourAutoIncColumnName> LAST AUTOINC 0;

Best regards
--
Fernando Dias
Easygate, Lda

Hi, Andrej

> Is there a way, I can reset that AutoInc?

I think emptying the table, rather than deleting the records, will reset the auto
increment to zero.

EMPTY TABLE table_name

Stu

Stuart,

<< I think emptying the table, rather than deleting the records, will reset
the auto increment to zero.

EMPTY TABLE table_name >>

Yes, you are correct also.

--
Tim Young
Elevate Software
www.elevatesoft.com