Hello.

There was a bit of redundancy in this article. Therefore, please forgive me if I overlooked your mention of a very useful byproduct of using TRUNCATE.

If your table has an auto-increment column, the TRUNCATE command will RESET the internal counter ... whereas DELETE will not.

For example, if your table has an auto-increment column with seed=1, and there are 20 records in your table, the last record's AI value will be 20. If you perform a DELETE and then add a new record, the new record's AI value will be 21. Conversely, if you now perform a TRUNCATE and then add a new record, the new record's AI value will be 1.

This is a very important and useful feature of the TRUNCATE command.

Kind Regards and Happy Thanksgiving to those of us here in the States!

Paulie D.