Reset autonumber column

[aspfun]

There is a autonumber column in one table Order.
Everyday I need delete records in Order and then append records into it.
Doing so, autonumber keeps on increasing.
Is there any way to reset Autonumber from 0 after deleting records?

 

[pbaldy]

I'd say "who cares?", but you can try a compact/repair after deleting the records. That will sometimes reset the autonumber.

 

[John Big Booty]

To expand a little on pbaldy's comment, most experienced developers will advise that; An Autonumber is for the database to maintain referential integrity. As the old saying goes, "An Autonumber is not for human consumption." so it should be irrelevant to the user what the autonumber is holding.

Having said that perhaps you will find a solution here.