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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DELETE FROM a table WHERE... 1
Record-Locking remains open after closing 0
Problem with deleting of records! 1
Linked SQL Tables don't report Cascading Updates and Deletes 2
Writing SQL code to delete duplicate records 0
Delete first record error with linked tables 7
Automatic deletion of subform's record 12
Modifying/Appending records between subforms 2

Back
Top