What's the difference between "Delete Rows" and "Truncate Table" under Data Management Tools?

[EmilyLee]

Hello:

What's the difference between "Delete Rows" and "Truncate Table" under Data Management Tools?  When do I use one over the other?

Thank you!

[AsrujitSengupta · Accepted solution]

DeleteFeatures_management or truncate?

Delete Rows—Help | ArcGIS for Desktop

Truncate Table—Help | ArcGIS for Desktop

Truncate Tool cannot be used with Versioned data. It does not allow you to select a subset of the data for deletion. It runs much faster because of this as it deletes the records using Truncate procedure in the databases.

Delete Rows or Delete Records, also deletes the records....but 1 by 1....not at one go.

Read through the links and let us know if you still have doubts or need any more clarifications.

[EmilyLee]

This is perfect! Thank you, Asrujit!