Can i reset an autonumber?

[joebickley]

Hi
I have always wondered if there is a way that i can reset a AutoNumber field back to 1. I have been doing some testing work with a database and i want all the counters reset

Thanks

Joe Bickley

 

[dvrobin]

The best way I can think of is to delete the field and add it back. You will have to reestablish any relationships and sync up any related tables.
Dave Robinder, MCSD
Programmer
Colorado DataScapes
Colorado Springs, CO
(719) 328-1111

 

[joebickley]

Yeah i have done something similar before, i just changed the datatype saved the table and then changed it back to an autonumber. But again you have to reattach all of the relationships. I just thought there may have been an easier way

Thanks All the same

Joe Bickley
MCDBA (wannabie)

 

[mc9901]

The autonumber should reset if you delete all the records in a table and then compact & repair. If some records remain in a table, the autonumber should reset to the highest existing autonumber in that table, plus one.

 

[joebickley]

nope that didnt work

thanks anyway