Clearing Test Data

  • Thread starter Thread starter anna
  • Start date Start date
A

anna

I'm in the middle of setting up a database but as I've been working I've
put in a bit of test data to make sure code and queries are working.

Is there a way I can delete all this and reset the Autonumber fields
back to 1. This data is not 'real' so I would rather it didn't remain.
 
Delete the records by simply opening up the table, selecting all records
(CTRL-A) and hitting delete.

Compacting the DB will reset the auto number to 1 but as the autonumber
is normally just used as an internal primary key why bother ?

As other posters have said the autonumber field should not really be
used for generating sequential numbers as it cannot be relied upon not
to leave gaps. Sequential numbers should be generated from a number
field which YOU control the value of.

PaulC.
 
Thanks.

No the numbers don't have to be sequential they are just there as
unique primary keys in a table. I just want to "clean up" a bit before
putting real data.
 
Back
Top