Auto Count / Increment Reset

[t5amec]

I'm redeveloping a DB for a new project, so have removed all previous records from relevant tables (to start a-fresh)

One snub, the ID fields in the tables are auto increasing from where they left off, rather than from 1

If anyone knows how to reset the auto counters, it would be very much appreciated

Thanks in advance

Make Sense? I hope so (-:

 

[TomCologne]

Try "Compact & Repair".

TomCologne

 

[Remou]

It is also a good idea to decompile, if there is any code in the DB.