Delete Duplicate Records from Access Table

[S M C]

Rahul,

1. DROP is a DDL command and DELETE is a DML command
2. DROP is faster than DELETE

Explanation: The delete command first stores the data that is going to be deleted. In a more advanced term, it is called a Rollback TableSpace. So this storage event first happens, and only then the rows are deleted. In the case of DROP, there is no storage, and all details and structure of the table is simply erased (removed, so to speak). Since there is no intermediate action, a DROP command is always faster than a DELETE command.

[littleiitin]

Thanks Sam for so detailed information...