topic Re: What's the difference between "Delete Rows" and "Truncate Table" under Data Management Tools? in Data Management Questions

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

EmilyLee — Mon, 06 Jun 2016 23:30:48 GMT

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!

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

AsrujitSengupta — Tue, 07 Jun 2016 00:07:26 GMT

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.

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

EmilyLee — Tue, 07 Jun 2016 15:02:01 GMT

This is perfect! Thank you, Asrujit!