Delete records

  • Thread starter Thread starter Dom
  • Start date Start date
D

Dom

SQL Server has a TRUNCATE command. THis will delete all
records in a split second and has the nice side effect of
resetting the autonumber fields to 1.

Does Access have something similar, or do you always need
to use the DELETE * FROM TABLE command. I am especially
interested in the speed difference. TRUNCATE will delete
any number of records in the same anount of time, usually
just a second.

Dom
 
Thanks Arvin, but that's not the answer I wanted. I need
to delete well over 1 million records every time a program
runs. I think I'll keep an empty template of the table in
the database, and just copy it when I need it.

Dom
 
Back
Top